Access Error: "Expression Error on Open..."

Body

Problem:

When a user opens an Access database, they receive something similar to the following error:
The expression On Load you entered as the event property setting produced the following error: Object or class does not support the set of events.

The expression may not result in the name of a macro, the name of a user-defined function, or (Event Procedure).
There may have been an error evaluating the function, event, or macro.

Cause:

The user is working with Access 2003 even though Access 2007 is installed. This is because of problems seen with Access 2007 opening the AEcommon databases. Even though Access 2003 is in use, a library from Access 2007 is trying to be loaded.

The same is true when attempting to open a 2010 database with Access 2007

Solution:

Close Microsoft Access
Rename the file C:\Program Files\Microsoft Office\Office12\MSACC.OLB to MSACC.OLB.OLD
Copy the file C:\Program Files\Microsoft Office\OFFICE11\MSACC.OLB to C:\Program Files\Microsoft Office\Office12\
Open Microsoft Access and try the operation again

Detailed Instructions:

Make sure Access is closed
Open the C drive from My Computer
Open the Program Files folder
If the files in this folder are hidden, click the link to show them
Open the Microsoft Office folder and then double-click on Office 11
Scroll down until you find MSACC.OLB
Right-click on MSACC.OLB and choose copy
Click the Back arrow to go back one level
Open the Office 12 folder
Scroll down to this copy of MSACC.OLB, right-click, and choose Rename
Change the name to MSACC.OLB2 and press Enter
Click Edit → Paste