I have an access 2007 database that has some VBA code in it. I need to open this database in Access 2010, but when I first open it I get an error that says:
the expression on open you entered as the event property setting produced the following error: file not found: VBE6.dll
I believe it's becuase Access 2010 references VBE7.dll when it loads up, and my database was built to reference VBE6.dll. I've tried putting VBE6.dll in the same folder that VBE7.dll resides in, hoping it would just get loaded up, but no luck.
What can I do to resolve this?