467,858 Members | 1,699 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,858 developers. It's quick & easy.

Maiximum forms and tables

Microsoft Access help says the maximum number of Modules, Forms, and
Reports is 1000. It appears that linked tables do not count. What
about local tables?

Help also says that the maximum number of open tables is 2048
(or less). That would seem to leave linked tables out of the above
mix.

Can anyone comment on these limits or quote personal
experience?

Thanks,
Hank Reed
Nov 12 '05 #1
  • viewed: 1345
Share:
1 Reply
I am not familiar with early version specs, but from 97+ I beleive the
limits are 32K for database objects. A database object is a table,
query, form, report, module, macro (i think), relationship, and a few
other things.

I am not familiar with 1000 as a limit for anything, all the limits I
know of are binary powers.

Also, in my experience, I have a database with 300+ forms, 400+
reports, 200+ tables, and 300+ queries. I don't know if you'll find
many bigger than that.

Hope this helps.

-Ben
ha********@aol.com (Hank Reed) wrote in message news:<f4*************************@posting.google.c om>...
Microsoft Access help says the maximum number of Modules, Forms, and
Reports is 1000. It appears that linked tables do not count. What
about local tables?

Help also says that the maximum number of open tables is 2048
(or less). That would seem to leave linked tables out of the above
mix.

Can anyone comment on these limits or quote personal
experience?

Thanks,
Hank Reed

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Charles E. Pelkey | last post: by
39 posts views Thread by Zak McGregor | last post: by
8 posts views Thread by T. Bjarne | last post: by
reply views Thread by Anonieko Ramos | last post: by
3 posts views Thread by Geraldine Hobley | last post: by
10 posts views Thread by Jim Devenish | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.