File Size and Application

G

Gary DeForest

I am trying to create a Laboratory Management System and I am curious as to
how far one can go using access 2003. I have heard that when an access file
gets so large it becomes quite a maintenance chore with reparing data and
such. The number of users doesnt concern me but the size of the file does.
I can easily see this file being 75MB in time. Obviously I could use
something like SQL server as a back end but will Access handle this itself?

Thanks
Gary DeForest
 
K

Ken Snell [MVP]

ACCESS file limit = 2GB.

75MB is pretty small size.

"Corruption" and data repair are results of many users using a single ACCESS
file. Check out splitting the database into a backend (data tables) and a
frontend (queries, forms, reports, etc.) files. Each user gets own copy of
the frontend, and the backend is put on the network in a shared folder.
 
Top