Maximum number of pcs connected to access

  • Thread starter Thread starter Jorge Novoa
  • Start date Start date
J

Jorge Novoa

Hello everyone!

I need to know hoy many simultaneous pc's connected to an access
client/server MDB can it be?

Can access 2003 handle 50+ connections?
How about access 2007?

Thanx a lot!
Jorge Novoa
 
I've had 53 connections to a well-designed Access 2000 format Jet database.
Most were actively editing the 105+ MB database. It also depends upon record
structure and quality of the network. I know of a database in Texas with 75
concurrent users. Officially Access/Jet can handle 255 users, but I believe
that's pushing it. If you original spec call for 50 + users, you might
consider using a SQL-Server or SQL-Express back-end. Specs have a bad habit
of expanding rapidly.

I have no idea how robust the the Access 2007 engine is.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error in query 2
Open external files from access 2
Issue with dates!!! access inverts dyas with months 2
Slow connection thru VPN 6
Multi-user connection 2
Whats the maximum number of rows Access 2007 can take? 3
Deploying Access 2007 to PCs with older versions of Office 10
How do you connect Word 2003 to Access 2007 accdb database??? 3

Back
Top