Ms-Access

S

supraba

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

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)
 
Top