What is the maximum number of tables there can be in an access fil

H

Haider Butt

I wanted to know waht is the mmax number of tables there can be in an access
file and the max number of rows in a table ?
 
J

John Vinson

On Sat, 20 Aug 2005 19:00:02 -0700, "Haider Butt" <Haider
I wanted to know waht is the mmax number of tables there can be in an access
file and the max number of rows in a table ?
Click to expand...

See "Specifications" in the online help. There is no specific number
of records, only an overall limit of 2 GByte (1 GByte in Access97 and
earlier) for any single .mdb file.

John W. Vinson[MVP]
 
A

Arvin Meyer [MVP]

Haider Butt said:
I wanted to know waht is the mmax number of tables there can be in an access
file and the max number of rows in a table ?
Click to expand...

The maximum data is 2 GB, but you really should be moving to a different
engine before then. You can have about 2000 tables open.

If you open Help and type "specification" into the index (without the
quotes) you'll get lists of Access specs.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top