As with Microsoft Access 2007, the RTM code for Microsoft Access 2010 also seems to have a problem updating the Access Object library reference in the registry on x64 computers (mine happens to be running Windows 7 Ultimate x64).

Below are some of the symptoms you may encounter.  The fix is a manual one:  Do a search of your registry for the path to the Access 11 MSACC.OLB file (i.e. search for “C:\Program Files (x86)\Microsoft Office\OFFICE11\MSACC.OLB”).  Modify the registry key it finds to the Office14 folder instead.

In my case, the location where it found it was here:

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\Wow6432Node\TypeLib\{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}\9.0\win32]
@=”C:\\Program Files (x86)\\Microsoft Office\\OFFICE11\\msacc.olb”

Updating that value to this fixes the problem:

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\Wow6432Node\TypeLib\{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}\9.0\win32]
@=”C:\\Program Files (x86)\\Microsoft Office\\OFFICE14\\msacc.olb”

Symptoms

My computer configuration is a Windows 7 computer with Microsoft Access 2003 installed from the Microsoft Office 2003 setup routine.  I also have my application installed, which installed Microsoft Access 2003 runtime to C:\Program Files (x86)\Access 2003 Runtime\.

When I launch Microsoft Access 2010, the Office Installer loads:

  • The main access windows gets displayed.
  • If you try creating a new .accdb from the main menu of the Access 2010 app you see this:
  • On completion of this dialog, the system displays the following reboot prompt:
  • If you actually reboot, and then try to re-open the app, the exact same process happens – endless cycle of configuring / reboot prompts.
  • If instead, you answer no to the reboot prompt, the database will still open, but now the Access OLB references are wrong:

(You can view the references by pressing ALT+F11, or press CTRL+G, then go to the Tools menu and choose References…

Note that the 2nd reference is for Microsoft Access 11.0 Object Library, but should read Microsoft Access 14.0 Object Library

Rebooting, running a repair on Office does not fix this problem.

If you get this problem, it seems the only fix is to edit the registry manually using the instructions above.

If this solution worked for you – leave a comment.

Advertisements