Maximum records in a table

  • Thread starter Thread starter Stevie
  • Start date Start date
S

Stevie

Could you please advise the maximum amount of records that
MS Access can store in a table?
 
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.
 
Back
Top