Number of records in Access

  • Thread starter Thread starter Woz
  • Start date Start date
W

Woz

If your question is how many records can access have (max
sorage) I do not remember the exact amount but it's a bit
over a gig. At least that's when it stopped importing off
my Oracle and SQL 2000 database. So I make a couple
smaller database files and then just linked them up. Local
sorts / joins ex on over 15GB of data and not problems. I
would just suggest you do it on a server class computer.

:)
 
Access 97 had a 1GB maximum file size, later versions increased that to 2GB.
But note that is file size, not number of records. There's no direct
relationship between file size and number of records. The size of a record
can vary widely, depending on the number and data type of the fields.
 
Back
Top