There is no explicit limit. A single .mdb file is limited to two
gigabytes (two billion). In practise, I know of tables in production
databases with 20,000,000 records; more commonly you'ld want to go to
a client-server system (perhaps with an Access frontend) once you hit
a couple of million.
There is no max number of records limitation. The limit is a file size of 2GB
per .mdb file. With splitting and linking of files, you can squeeze in more
records.
I've seen Access databases with over 1 million records in them and run well.
I've also seen badly designed databases with under 100K records and plenty of
open space run very, very slow.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
