Max # of records in Access 2002?

  • Thread starter Thread starter Dwayne
  • Start date Start date
D

Dwayne

All,
Does anyone know what the maximum number of records that
are allowable in the Access 2002 environment? I have
often created sample sizes that have exceeded Excel
capabilities and was wondering if Access had the same
limitations in the number of records or rows of data.
 
Dwayne said:
All,
Does anyone know what the maximum number of records that
are allowable in the Access 2002 environment? I have
often created sample sizes that have exceeded Excel
capabilities and was wondering if Access had the same
limitations in the number of records or rows of data.
Click to expand...

There is no "record limit". The limit is that no single table or file can
exceed 2 GB.
 
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

work around max records 2
Determine Max Record 1
Maximum record size and maximum number of records 3
access 2.0 limts 2
Record limit CSV import and more - Access 2002 SP3 1
About Access limits 15
File size in Access 2003 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Back
Top