There's no explicit limit; a single .mdb file can hold up to 2 GBytes.
The largest in-use database that I'm aware of has some 50,000,000
records in the largest table. In practice I'd start looking at a
client-server solution by ten million or so, perhaps more or fewer
depending on the nature of the application.
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.