There is no answer to this question except "It depends". The absolute
maximum size for Access 97 is 1GB, Access 2000 and up is 2GB. But that is
just the maximum.
Factors that can influence performance:
1) RAM - the more the better
2) Network - how fast is it?
3) Configuration - Is the database split? Is the FE on the workstation? BE
on the network?
4) Sharing - is the database shared? by how many?
5) Indexing - is the data indexed properly. Too few indexes results in slow
searches. Too many indexes results in slow saves/updates.
6) Application Design - this is a key issue that is often overlooked. There
are many ways that an application can be designed to enhance performance.
One example is if you use a form bound to a table and then use the Filter
property to show the record you want. This is very wasteful. Instead, you
should limit the records to just the ones you want through the use of
queries.
7) Size - of course. But this is varies in importance based on the other
factors.