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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ?
 
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]
 
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
 
You must log in or register to reply here.

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

Access Table - Maximun Number of Fields? 4
Whats the maximum number of rows Access 2007 can take? 3
About Access limits 15
VBA - retrieve data on last create named range from previous inserted named range 0
check boxes not set when copied 1
the size of an single project 5
Maximum record size and maximum number of records 3
How big can an Access table be? 5

Back
Top