Maximum Number of Allowable Tables

[Michele Lanik]

Hello,

I need to know the maximum number of tables allowed in a
database. Each table will be small (about 50-150 records).

 

[Cheryl Fischer]

Access 2002 allows 32,768 Objects (tables, forms, queries, reports, etc.) in
a database, with no specific limitation on the number of Table objects. You
can check the specifications for your version of Access by opening Help and,
in the Answer Wizard, typing the word "specifications" (without quotation
marks).



hth,

 

[John Vinson]

Hello,

I need to know the maximum number of tables allowed in a
database. Each table will be small (about 50-150 records).

Lots and lots... FAR too many to make this database user friendly.

Could you explain WHY you want to violate relational design principles
in such a drastic manner!? Storing data in tablenames - as you're
apparently doing - is NOT working with Access, it's fighting against
it.

Could you consider having *ONE* table with an additional indexed field
that lets you distinguish these 50-150 record sets of data? You could
then have a parameter Query which gives you just those records by
selecting them from the table; this query can be used as the
recordsource of a Form, or a Report; or it can be exported, searched,
sorted, or used as the basis of another Query. What benefit do you
expect from having hundreds of tables?