Access 2000 limit ???

[Sean]

I am getting an error in Access 2k...

"The Visual Basic for Applications project in the database is corrupt."

I looked on the net and the KB article
http://support.microsoft.com/default.aspx?scid=kb;EN-US;225949

stated that there were too many vba modules in there.

I have confirmed that this is the reason, by importing less objects and
everything was fine.

The troublesome database contains about 500 forms , 200 linked tables,
heaps of queries and reports.
Works fine under 97...

Has anybody out there successfully dealt with this problem other than
deleting objects?????????

or know anything about this?????

 

[Arvin Meyer]

Try importing the objects into several databases in Access 97. Set the
HasModule property to No if there isn't any code in the form.

Convert each of the smaller databases to Access 2000. Once they have been
compiled in Access 2000, combine them into a bigger database.

You might also consider organizing the larger database into separate tasks
and building a separate database for each subset. I find it difficult to
believe that every user requires all 500 forms.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[david epsom dot com dot au]

Has anybody out there successfully dealt with this problem other

deleting objects?????????

We use library modules (MDE) instead of putting everything
into one database.

FWIW, we can put ALL of our A2K libraries into one 80MB
XP database without any problems. (Data is separate).
Slow to load though.....

(david)