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

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