VBA Modules Disappearing

M

Mike Thomas

This problem has come up again after a few weeks in Access 2000 / Windows XP

After apparently corrupting an mdb, I created a new one and imported the
objects from the corrupted mdb. There was some problem with the AutoExec
macro, which was calling a VBA Procedure in a VBA module.

After copying all of the objects, I deleted the autoexec macro.

Whenever I close the mdb and reopen it, all of the modules, about 12 of
them, are gone. When I reimport them and check the libaries, Microsoft DAO
3.6 Object Lib, Microsoft Vis Basic of Apps Ext 5.3, and Microsoft Excell
9.0 Object Library have become unchecked. I check them, do a compact and
repair, and close the mdb. When I reopen it, the modules are gone and the
libraries are unchecked again.

Does anyone have any idea what can be going on here/

Many thanks
Mike Thomas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top