Chances are, no one else uses the databases you create. If you are asking this question, the entire problem does not apply to you. It would require administrative control, be an exercise in frustration with the UAC dialogs, and consume more time than it was worth. You could run setup.exe from each version of Office every time you wanted to switch versions, but this is no solution.
Malware can install itself as in Windows XP and earlier.Īssuming you are logged in as a computer administrator, the steps are: Warning: This degrades the security of Windows. The simplest (and least safe) workaround is to disable UAC, and use an administrative account.
Note: after you make this change, you may need to switch to another version and switch back before Access will register the correct library. Run As Administrator is not needed for this version. Check the Run as Administrator box.Įach time you start Access, you will need to click the Continue button in the User Accountįor Access 2007, you can use a normal shortcut, i.e. Right-click the shortcut, and choose Properties.(Right-drag them from the folder in Computer.) Create shortcuts to msaccess.exe from each version of Office.(These lack the Run As Administrator option.) Delete any shortcuts created by installing Office.(As always, exercise care when editing the registry.) Option 2: Use Run As AdministratorĬreate a shortcut to run each msaccess.exe as an administrator.
Under Permissions for Users check the Allow box beside Full Control.Įven though the key refers to 9.0, the solution applies to all versions from Access 2000 onwards.In the Permissions dialog, select the Users group.Right-click it, and choose Permissions.This suggestion from Graham Mandeno (Access MVP) modifies the Windows Registry so that Access always runs with full permissions: To read more about what References are and which ones apply to each version of Access, see Solving Problems with Library References. Office library), but incorrectly attempts to use the Access 12.0 library (since Access 2007 was used previously.) It correctly identifies the Office 9.0 library (since no database had been opened using the
The code cannot compile using the library of the wrong version, so no code works. Under Vista, programs do not have the privilege to alter the registry.Īccess therefore runs with the last registered library. The Access and Office library references are adapted to the version of Access you open.