Number of Tables Limitation

  • Thread starter Thread starter PCGrammy
  • Start date Start date
P

PCGrammy

What is the limitation on the number of tables that an Access 2007 database
can contain?
 
What is the limitation on the number of tables that an Access 2007 database
can contain?
Click to expand...

Why do you ask? The Help for Specifications might be useful; for one thing it
says that you're limited to 32768 objects (tables, forms, reports, macros,
modules) in the table, which should be plenty.

If your database design includes large numbers of tables, particularly large
numbers of *identically structured* tables, your structure needs to be
reconsidered. A database with over a hundred tables is a BIG database (and
yes, I've worked with bigger databases); one with tens of thousands of tables
is probably not correctly structured (but still possible with Access if you
insist).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Limit on number of fields in MS Access forms 3
Increase Record Limit in Auto Number 4
Limit on number of tables? 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Keeping Track Of Daily Sales 6
Linking Tables 3
table help 0
Limit for relationships from a field 2

Back
Top