Vista and Access 2007/2003

[OzarksAdv]

I have a customer that did not read my recommended hardware specs and bought a Vista machine with Office 2007 preloaded on it.

My application uses a Access 2003 database and it is working fine in the Vista environment. The database utilizes Access security and has a database password.

My problem is that I can't see any data that has been entered! I have ran queries and opened the tables, but it is as if there is no data in the tables. However, my application can still read the data...this is a very weird problem! This is a tech support nightmare!

Has anyone had a similar problem?

Thanks for your help!

[boblarson]

Did you, or your client, make sure to set Access itself (the main program) to run AS ADMINISTRATOR in Vista? That is an important detail.

[OzarksAdv]

Thanks Bob, I'll give that a try. I did set our db to run as admin, but not the MSAccess.exe file itself.

[boblarson]

Yeah, the db doesn't matter; it's the program that does.

[OzarksAdv]

I set Access to run as Administrator, and still have the same problem.

It appears like there is no data in the tables, however there is because the application sees it.

[boblarson]

Originally Posted by OzarksAdv

I set Access to run as Administrator, and still have the same problem.

It appears like there is no data in the tables, however there is because the application sees it.

Not sure about that, but if you can run the Compact and Repair and then zip it and post it (or, if too big email it to me) I can take a look.