We have a Microsoft Access 2003 database that is being used over a corporate intranet. We have several locations that are spread out over roughly a 150 mile area. The database is being served from roughly the middle of that area (Central). We have users that are roughly 70 miles West of the central office, and users roughly 80 miles to the East of the central office.
We have approximately 45 concurrent users accessing this MC Access 2003 database over the network from a combination of these three regions (East, Central, and West).
The "Active" database is approximately 45MB, and the "Archive" database is approximately 180MB.
My questions are:
What are the generally accepted limits on a MS Access 2003 database over a network?
What is the maximum size that a MS Access 2003 database should be if it's being used over a network?
Let me include that I am well aware that MS Access 2003 databases are not meant to be used over a network. I am just an intern who is here for 2 months. I am trying to work with this corporation to move to a significantly more efficient platform (such as MS SQL, Lotus Notes dB, or Oracle), but at the moment they are stuck with MS Access 2003.
Thanks for any suggestions everyone.