Microsoft Access 2010 Invalid Reference to Access 11 Object Library on x64 computer

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: