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.
