Table size

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Hi

I'd like to know how many record can Access Database
support, In my specification I risk to have more than 300
000 record, and everytime the user Add I'll have more
records

I was thinking to archive the data of this table but the
ID (Primary key is used in another Table)

Did somebody have an idea how can I resolve the problem
of size of the table if I'll risk to have problems

thanks a lot
 
There is no limit to the number of records that can be contained in an
Access table. The limitation is the size of the database (MDB) file: 1 GB
for Access 97 and older - 2 GB for Access 2000 and newer.

Additional specifications can be reviewed by opening Access Help and typing
"specifications" in the Answer Wizard.
 
Back
Top