Multiple Users

[Jo Walker]

I am currently creating an Access Database, and was wondering how many users
can go in and update or edit at one time. Or is there only one person that
can go in and do these updates!

Any help would be much appreciated.

Many thanks

Jo

 

[Golfinray]

You want to split the database and then you won't have the problem. Splitting
means that you separate into a Frontend (FE) and Backend (BE). The Tables go
in the BE and usually go on a drive on your LAN. The FE contains the queries,
forms, and reports and a copy of that goes on each users computer. Now all
users can have access at once. Remember that the BE file has to have
read/write/edit/ and delete rights for all users, and so does the folder it
resides in. See Joan Wild's web site at www.jmwild.com or Allen Browne's
website at www.allenbrowne.com for more info on how to split.

 

[Jerry Whittle]

The posted limit is 255 concurrent users. The real limit is about 10% of that
if you have a well designed database. Golfinray is very right about splitting
the database.

In a nutshell, about 25 users in a well-designed database at the same time.