Access 2013 Issue Loading VBA
Posted on 2013-06-12
Hello, I am using MS Access 2013 64-bit (15.0.4481.1001), and in that product I created a database, which includes quite a bit of VBA code. Today, when I open the database, I receive the error:
"The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all code from modules, forms and reports. You should back up your database before attempting to open the database and delete the VBA project. To open the database and delete the VBA project, click OK."
I haven't done anything that I'm aware that might cause an error like this. I haven't made changes to the code in weeks. I haven't installed any updates recently. I haven't uninstalled, reinstalled, or messed with the installation of Access. It's just: one day, my database opens and works as expected, and the next day I get this error.
I don't even mind doing some recovery work if I have to. The data portion of the database is intact. My biggest concern is retrieving all the VBA code, which took several months to write and debug. Yes, I do have backups of the .accdb file, but loading the backups shows the same error.
How can I either a) get the database to open with its VBA intact or b) save the VBA code somewhere as text before taking the prompt's advice and deleting it?
I use this database mini-app daily and rely on it. Any help is greatly appreciated!