How many simultaneous users?

  • Thread starter Thread starter Rod
  • Start date Start date
R

Rod

I lack experience of multi-user Access systems, hence my question.

I want to set up a central database (Access 2000) which can be accessed over
a network. The application is very simple with a form with a flat table
behind it. At most there would be 2000 records. Everything is as simple as
it could be. Each user would find the record, edit it and move on, this
process being slow as a lot of talking is going on at the same time.

So how many users do you think could use this system simultaneously, without
me needing to start doing clever things.

many thanks

Rod


--
 
So how many users do you think could use this system simultaneously, without
me needing to start doing clever things.
Click to expand...

Twenty or twenty-five if they're actively updating; a hundred or so if
they're just reading.
 
I have a similar problem...

actually, only 1 person can access our database at this
time. I don't use any server software yet.

As you know, if 1 users makes modifications all other
persons only have READ-ONLY access.

How can I overcome this w/o spending a great deal of
software packages?

Tom
 
actually, only 1 person can access our database at this
time. I don't use any server software yet.
Click to expand...

This is the case only if that user is actually modifying VBA code or
Form/Report design. This is one good reason to split your database -
each user should have their own copy of the frontend, with the user
interface, linked to shared tables in the backend.
 
Back
Top