troubleshooting Question

Max number concurrent network users in Access 2003?

Avatar of xxdesmus
xxdesmus asked on
Microsoft Access
10 Comments1 Solution1666 ViewsLast Modified:
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.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 10 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros