Maximum records in a table

S

Stevie

Could you please advise the maximum amount of records that
MS Access can store in a table?
 
J

Jeff Boyce

Stevie

(for prurient interest, or is there an underlying business need?)

The theoretical maximum would be something just under 1 Gbyte of rows. To
reach that, you'd need a single table in your database, with a single,
one-byte field. 1 Gbyte of data (2 in more recent versions, but using
UNICODE, which takes up twice the space) is the max size of a db.

Check Access HELP under "specifications" for more, well, specific info.
 

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