Number of tables/forms allowed in Access 2000 (and higher)

[Guest]

I'm designing an application that requires a very large number of forms and
tables.

I am currently using Access 2000, but the application will be rolled out on
2002. (I know there are differences between the two, such as the length of
the rowsource property of listboxes is limited to 2048 chars in access 2000,
but not access 2002.)

Can anyone tell me the maximum number of forms allowed in an access
database. It would be very helpful If I could get the figures for access 2000
and 2002.
I have already searched the help files in access but I could not find this
information.

Many Thanks
Alan

 

[Arvin Meyer [MVP]]

You can have 32,768 objects in the database, At any one time the maximum
number of tables that can be open is 2048 (less any opened internally). In
the help files search for the word "specification".

 

[Guest]

Arvin,

Thanks for your swift response. That was the answer I was looking for (I was
hoping you wouldn't say the limit is 255 objects.)

Alan