Table size

R

Rick B

go to help and type "SPECIFICATIONS"

Rick B

Hi All,

How many records can a Table in Access 97 can contain.

Thanks,
BR
 
J

John Vinson

Hi All,

How many records can a Table in Access 97 can contain.

Thanks,
BR

There is no explicit limit; the entire .mdb file cannot exceed 1 GByte
(a billion bytes). In practice, 10,000,000 records is getting big
enough to seriously consider going to client/server.
 

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

Top