Increasing Number of Records in MS Access

  • Thread starter Thread starter Cheryl
  • Start date Start date
C

Cheryl

Is there any way to increase the number of records allowed
in an Access Table? I do believe the default for Access
is ~66,000 - I need for my table to handle ~400,000
records.

Many thanks in advance!
Cheryl
 
Hi Cheryl,

There's no specific limit on the number of records in an Access table,
and millions of records are possible. Maybe you're thinking of Excel
worksheets, which do have a limit of 65536 rows.
 
Hi, Cheryl.

John's right: there really isn't a specific limit on the _number_ of
records in a table. The limit is on the amount of disk space that those
records need. The maximum space that an Access 2000, XP, or 2003 database
can hold is 2 GB. Access 95 and 97 databases can hold up to 1 GB. If your
table needs more than the 1 GB or 2 GB of space available to store those
~400,000 records, then Access isn't the database to use. In that case look,
to another DBMS, such as SQL Server or Oracle, for data storage.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
 
Back
Top