Access file Sizes

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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?
Click to expand...


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
 
Back
Top