Records

  • Thread starter Thread starter Andre Adams
  • Start date Start date
A

Andre Adams

How many combined records can Access hold. I have a table that has 120k
records. I'm about to split my data, so now, it's about to double. When do
I want to start considering creating another database?
 
How many combined records can Access hold. I have a table that has 120k
records. I'm about to split my data, so now, it's about to double. When do
I want to start considering creating another database?

When the entire size of your database approaches 2 Gigabytes.

The number of records is not a limitation. I know of working Access
applications with 20,000,000 records in the largest table.
 
Back
Top