VB Modules Disappearing

[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

 

[Ken Ismert]

Mike,

More general causes of corruption:

* Avoid multiple users sharing the same front end. To this end:
1. Split your db if you haven't already.
2. Put the front-end (forms, reports and code) on the user's
computer
3. Put the back-end (tables) on the network.

Having multiple users sharing the same front-end on the network was a
source of constant problems for me. When I moved the front end to each
user's machine, many corruption problems went away.

* Be careful with ActiveX controls:
1. You can find lists of 'Supported ActiveX Controls' for Access on
the Microsoft Knowledge base.
2. Even if a control is on the list, it may not work for you. I've
had luck with the Common Controls (Comctl32.ocx), but not Common
Dialog (Comdlg32.ocx)

It is prudent to use only the ActiveX controls that you really need.


Some more thoughts,

-Ken