Records

[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?

 

[Linq Adams via AccessMonster.com]

There are no limits to records, per se, just the total file size limit of 2
GBs (for all versions post-97.) There are Access apps out there with over 1,
000,000 records; it just depends on the size of the records and the
number/complexity of your forms, queries, reports, etc.

When you do start approaching the 2 GB limit, you can

Split your database (if you haven't already) placing the tables in the back
end and everything wlsw in the front end.

or

Use multiple back ends, placing tables in one, other tables in another, and
linking to these tables.

or

Split your database and use an alternative for your back end such as MySQL or
Oracle.

 

[John W. Vinson]

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.