The Visual Basic for Applications project in the database is corrupt

[decktec_inc]

we have 4 xp machines running access 97 and 1 w2k machine running O2k.
We get "The Visual Basic for Applications project in the database is
corrupt." when we try to launch the access file on the access 97
machine over the network. Then "file not found"

any help would be appreciated


thanks

 

[Allen Browne]

You have 5 computers all trying to open the one Access 97 MDB file?

Split the database into 2 files:
- an MDB containing just the tables, in a shared location, and
- an MDE containing linked tables, and everything else (queries, forms,
reports, code, ...)

If splitting is a new concept, see:
Split your MDB file into data and application
at:
http://allenbrowne.com/ser-01.html

If the MDE is a new concept, see MDE in the Access 97 help files.

The splitting will avoid the cause of corruption, and the VBA cannot corrupt
in an MDE.

 

[decktec_inc]

thanks allen, i will try that fix.