Access XP Limitation

[Patrick]

We have 422 Forms, 421 Reports and 40 Modules. The
limitation on objects having HasModule property set to
True is 1000. The count max for us is 883 and I don't
know why it's less then 1000?

Is there a way, walk around or patch to put that
limitation higher.

I really need a quick solution.

 

[Patrick]

Thank you for your quick reply. I'm not sure I understand
all the impact. Can you give me a specific example on how
you would create those library databases. As in Visual
2000 our users can print a report directly from a Form.
And I don't see how to disassociate them in your schema.

You can visit our Web Site on www.visual2k.com

 

[Paul Overway]

Library databases are created in much the same way that a "normal" database
is created. You create a database, make an MDE for that database, and then
set a reference to the library when using it in another database. However,
instead of putting all your code in one mammoth MDB, you isolate
functionality logically within separate MDBs and make function calls to the
library/libraries as needed. You might be surprised to know that many
functions with Access are actually found within a library database, i.e.,
various wizards. Yet, this functionality is used within your database while
you are developing.

The following link points to a white paper for developing add-ins and
libraries. The article refers to Access 95/97, but much of the information
and methodology still applies.

http://support.microsoft.com/default.aspx?scid=kb;en-us;143270

I won't kid you...this isn't easy to do...especially, if you haven't planned
for it. But it does make your app/code more manageable, and allows for code
reuse without cutting and pasting. And with an app like yours, it really is
a necessity.