Multiple Users of an Access Database

[Patricia O''Donnell SSJ]

Can several users (3 or 4) use an Access Dabase at the same time? The
database would be located on a central server and the users would be at
different workstations.

If this is possible, where can I find instructions. Is there a keyword that
I can use to look for instructions?

Thanks! Pat

 

[Douglas J. Steele]

Several users can use the database concurrently, but you really should split
the application into a front-end (containing the queries, forms, reports,
macros and modules), linked to a back-end (containing the tables and
relations). Only the back-end should be on the server: each user should have
his/her own copy of the front-end, ideally on his/her hard drive.

 

[John W. Vinson]

Can several users (3 or 4) use an Access Dabase at the same time? The
database would be located on a central server and the users would be at
different workstations.
Yes.

If this is possible, where can I find instructions. Is there a keyword that
I can use to look for instructions?

Access allows multiple users in a shared database, but it's always much better
to use a "split" database application. This has one .mdb or .accdb file - the
"backend" - containing only tables; each user has their own copy of a
"frontend", usually a .mde or .accde file, containing the forms, reports,
queries, etc. See

http://www.granite.ab.ca/access/splitapp/

for a thorough discussion.