dcsimg
Results 1 to 5 of 5

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

  1. #1

    Thread Starter
    New Member
    Join Date
    Oct 2013
    Location
    California
    Posts
    15

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

    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.

  2. #2
    PowerPoster Arnoutdv's Avatar
    Join Date
    Oct 2013
    Posts
    3,433

    Re: Win 7 - VB6 - MSAccess - and UAC issue

    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

  3. #3
    Frenzied Member
    Join Date
    Dec 2008
    Posts
    1,187

    Re: Win 7 - VB6 - MSAccess - and UAC issue

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

    Rob

  4. #4

    Thread Starter
    New Member
    Join Date
    Oct 2013
    Location
    California
    Posts
    15

    Re: Win 7 - VB6 - MSAccess - and UAC issue

    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.

  5. #5
    Frenzied Member
    Join Date
    Dec 2008
    Posts
    1,187

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

    Would you let us know where you finally store it

    Rob

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width