Maximum no. of records (Access 2000)

Topic

New Reply

(Edited by HansV on 31-Jul-03 14:48. Changed app to Access instead of Outlook)

Does anyone know if MS Access tables have a maximum limit of the number of records before it becomes unstable?

Reply | Quote

Replies

An Access database can become up to 2 Gigabyte in size, but it will probably develop problems well before that. Apart from that, there is no theoretical limit to the number of records. I have worked with tables of about a million records without problems, but I don’t know how much further you can go.

Reply | Quote

Thank you…Susan

Reply | Quote

Susan,

I am currently running a database that has two tables with 4 million or more records without any problems over the last year.

Reply | Quote

I am currently running a database that has two tables with 4 million or more records

That’s quite a contact list you are running there, Gary!

Reply | Quote

Nope – No contacts – Just a lot of budgeting and earned value data from MPM spanning 1998 through 2015.

Reply | Quote