I don't know how many of you use Access for reporting. I've been
using it for 18 years now (both in my last position and this one), so
I've very familiar with it, I can get it to give me information I
can't get out of anything else like Excel, which the Powerschool
examples of ODBC use all use, without a huge learning curve at least.
Here's what it's been doing to us since PS 7.11. Might not be the
exact version it started in, because I tend to only upgrade the server
once a year. If I go to a database that I attached a Powerschool
table to a couple of years ago, and open the database, the data looks
fine fine. If I open a new database, and attach that same table today
(let's say the courses table, for instance), and open it, instead of
seeing N course numbers, names, etc, I see the same record N times.
Queries on these newly attached give you nonsense results, too. We
created one query to pull all the courses from one school, and it gave
us results from a different school.
If I look at the data in the same table in Excel using ODBC via
Microsoft Query, it looks just fine.
I submitted a case to Pearson via Powersource, so I could attach
screen shots of the results instead of just describing the problem,
and two days later they wrote back and said "We don't support ODBC".
Well, thanks a lot. Anyone know how to fix this?
Brattleboro Union High School District # 6