File Size and Application

[Guest]

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

 

[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.

 

[Larry Daugherty]

Access will do the job for you.