Ms-Access

[Guest]

max number of tables supported by a Ms Access Database and what is the number
of record that table can hold?

 

[Allen Browne]

In the main Access window, open Help and enter: Specifications

 

[Joseph Meehan]

max number of tables supported by a Ms Access Database and what is
the number of record that table can hold?

I believe tables is 255 (if you have anything close to that you likely
have a very poor table design)

The older versions of Access were limited to a total file size of 1 gig,
current versions are 2 gig. There is no absolute number of records limit.
Generally Access can start acting flaky at about 80% of max size.

 

[Van T. Dinh]

I think you are thinking of number of Fields in a Table and the question is
the max. number of Tables in a database.

You can have up to 2 ^ 11 (2048) _open_ Tables so the max number of all
Tables is certainly bigger than 255. I believe the Tables are count as
objects and the max number of objects is 32K objects.

HTH
Van T. Dinh
MVP (Access)

 

[Joseph Meehan]

I think you are thinking of number of Fields in a Table and the
question is the max. number of Tables in a database.

You are correct. My bad.