Vista Access 2007 And Any Earlier Version
||This page is a stub. Please help us by expanding or merging it with applicable content
If you're running Vista, had a previous version of Access installed that you kept, and have installed Access 2007, you'll find you might have problems running database applications in your older version of Access. If you open the Visual Basic Editor and choose References from the Tools menu, you might find that the Access 12 library is loaded instead of the library for your version. What's going on?
All versions of Access check the registry when the program starts and fix it to point to the libraries for the version you are starting. But there's one hitch when you're running Access on Windows Vista. The new security features in Vista cause it to run all programs by default *not* with administrator authority -- even if you're logged on as an Administrator. To fix the registry, Access must have administrator authority.
So, if you have been running Access 2007 and want to switch back to an earlier version, find the shortcut to your earlier version, right-click it, and choose "Run as Administrator" the first time you go back to the old version. This will give Access the permissions it needs to fix up the Registry and run correctly. After you do this one time, you don't need to run as administrator again unless you start Access 2007.