Access file Sizes

[Guest]

Hello i have a Acess 97 DB running at over 70MB just now
however it has a poor performance record. i would like to
know what is the largest you would recomend letting an
access mdb file get before having to migrate to SQL ??
also what is the Max number of users access can take?

thanks

David

 

[davadvice]

hi thanks for that i was just a bit unsure as how large
access could get to before going to pot.
you have answered my question thank you very much

David

 

[TC]

Hello i have a Acess 97 DB running at over 70MB just now
however it has a poor performance record. i would like to
know what is the largest you would recomend letting an
access mdb file get before having to migrate to SQL ??
also what is the Max number of users access can take?

Poor performance is often the result of incorrect or insufficient indexing.

Does your database have a primary key defined for each table? If the answer
is "no", or "what is a primary key?", there is the cause of your problem.

HTH,
TC