maximum number of modules in access xp?

  • Thread starter Thread starter Andrew Brill
  • Start date Start date
A

Andrew Brill

Is there a maximum number of modules of 1000 in access xp? I've read that
it's 1000 in 97 and 2000.

I've been looking into a series of problems our development team are
experiencing with obscure errors and vanishing code modules when importing a
project into new db's (eg. through the use of sourcesafe).
We merged 2 smaller db's to create this db and we estimate that we may have
exceeded 1000 code modules.

Thanks,
Andrew
 
Is there a maximum number of modules of 1000 in access xp? I've read that
it's 1000 in 97 and 2000.

I've been looking into a series of problems our development team are
experiencing with obscure errors and vanishing code modules when importing a
project into new db's (eg. through the use of sourcesafe).
We merged 2 smaller db's to create this db and we estimate that we may have
exceeded 1000 code modules.

Thanks,
Andrew
Click to expand...

It is still 1000 in Access XP and also in Access 2003. This number
includes Form and Report modules. You can find the Access
Specifications under Help / Getting Started.

HTH
Matthias Kläy
 
That limit still exists in 2003, so it probably is the same in 2002. The
limit includes and forms or reports that have HasModule set to Yes.

While these is a limit of 1000 modules, you can put multiple procedures in
each module.
 
Thanks for confirming this.
We have very few actual modules but we can merge them I guess.
We do have >500 forms with code and >500 reports with code though.
We foudn 50 or so obsolete forms we can scrap and I think we'll end up
splitting the reports off into a seperate database
 
Back
Top