I have a 2003 Access database - mdb that I have been using a long time with a lot of code. Recently I have received the following message after opening the database:
Cannot file file VBA6.dll
I examined the references and found that the Visual Basic for Applications reference had changed from VBE6.DLL to MSVBVM60.DLL. The result has been that none of my code will run.. I tried various methods to change the reference back with no success. Finally
I restored a backup copy of the database from our backup system. That seemed to fix the problem.... for a day....
The next day the reference changed again...
Has anyone else experienced this problem? Or have any ideas?