[RESOLVED] Win 7 - VB6 - MSAccess - and UAC issue

[Greydog1]

We have a VB6 application that accesses a MS Access database with both DAO and ADO.

When running on Windows 7 (VB6 app is runtime executable) with different user accounts we have encountered a very strange occurrence. When running the application under an administrator account we key some entries into the database. When running the application on the same machine under a standard user account, the new entries made by the administrator account cannot be seen. Nor can entries made by the user account be seen by the administrator account. This is after the application has been closed between each session, so is not a matter of recordsets not being refreshed or anything like that.

The workaround we have found is to set the application to "Run as administrator". However, we are finding clients that do not want to set their users up as administrators, nor require them as standard users to key an administrator password to start the application up. We have also found a solution for setting the administrator password in the credential manager so can get around this.

However, my question is, why does there appear to be 2 separate versions of the database from the 2 accounts? Why are transactions made by one user not visible to the other user even after exiting? The database seems to be stored in two different virtual storage spaces. Is there some other solution to this issue besides requiring the application to "Run as administrator"?

Thanks for any help.

[Arnoutdv]

My guess is that the database file is stored in a location which you are not allowed to update, for example somewhere in the "Program Files" directory.
Since Windows Vista you are not allowed to write/update data in the these kind of locations.
The file updates are done, but in a virtualized file in a folder called "Virtual store"


You should the folder for application data:
http://msdn.microsoft.com/en-us/libr...(v=vs.85).aspx

[Bobbles]

Where are you storing the DB ?
Also are there multiple PCs involved, or where are these users ?

Rob

[Greydog1]

Ah ha! That is probably it. The database IS stored in the Program Files directory. I will give that a try and move the database to a new location. Thank you very much for the help.

[Bobbles]

Would you let us know where you finally store it

Rob