Can Access 2003 handle multiple, concurrent users? How many?

D

DFIChris

I'm currently using Access 97 and need to upgrade for many reasons, the most
important one is that I have about 15 people who need to add data to my
database at one time. Is Access 2003 better at handling multiple users than
Access 97?
 
R

Rick B

Not sure if one is any better or worse, but 15 users should be just fine on
either version provided you have a well-built database and you have split it
so the backend lives on a server and the frontends live on the user PCs.


Rick B
 
J

John Vinson

I'm currently using Access 97 and need to upgrade for many reasons, the most
important one is that I have about 15 people who need to add data to my
database at one time. Is Access 2003 better at handling multiple users than
Access 97?
Click to expand...

What specific problems have you encountered with multiple users?

With proper database structure (a split database with each user having
their own frontend linked to a shared backend database containing the
tables), either version of the program should be perfectly capable of
handling multiple users. I don't think 2003 is any better than 97, but
I don't think it's any worse either - both are quite capable. The
specifications say that there is a limit or 255 concurrent users; in
practice, some thirty or so concurrent updating users, or well over a
hundred read-only users, should be feasible.

If you have multiple users sharing the same united database... well,
DON'T. It will NOT work well.

John W. Vinson[MVP]
 
D

DFIChris

Joseph -

I didn't split my database; that's my problem, I now understand.

What I don't understand is Irish Math. Does it work because 3 - 2 = 1???

Thanks for your help!

--DFIChris
 
D

DFIChris

John, I didn't split my db; that's the problem.

To answer your question, when a user tries to leave a record after editing
Access sends an error message saying that there's not enough memory and that
the action failed. My user then calls one other user in the db, they log
out, and my user can save the data.

Thanks for your help and the information about the versions of Access.

DFIChris
 
D

DFIChris

Thanks, Rick. I didn't split my database, it's rickety. Now I know what to
do. Thanks for your help.

DFIChris
 
Top