Maximum Records before system slows down?

[pepperca]

I have a database with about 12 users. About how many records can you have before you start to see a noticable difference in the speed the database runs. I have about 6 tables, 3 of them are linked, they contain the most data. One is Customers, the other two are Orders and MaterialOrderd.

Thanks,

Cindy

 

[psemianonymous]

I have seen a 350MB database work fine (Access 97, not even split, ~4 users).

I've also seen a 70MB database work fine with ~10 concurrent users, one search/lookup form they used had 20000 records, and they used it often. No huge problems.

You're probably good until you approach the size limits of Access (1GB or 2GB).

But no one really knows for sure. It depends on too many variables for me to be able to say 'yes','no', or 'maybe'. So I'll go with 'Yes, probably'.

Also, I wrote a FAQ about this, though it doesn't have any more detail than above.


Pete
How many (max) users can Access support? faq181-4462