Access 2000 Sharing with 5 users

E

entry door

We have set up an Access database on our server SBS2003 and can read /write
from five workstations. Problem is only one user can interact with the
database at a time. Can more than one user access the database at the same
time? What setting would need to be changed. Currently the database opens in
shared view.
Thank you for your help.
 
G

Guest

have you split the db into front end/backend?
in theory,
the server (backend) should have the tables.
the workstations(frontend) should have the form, queries,
reports, ect and be linked to the back end.
 
V

Van T. Dinh

Yes. However, you need to make sure each use open the database in "Shared"
mode rather than "Exclusive" mode. However, this tends to create
corruptions in your database.

Thed each user should have a copy of the Front-End on his accepted way is to
spit your database to Front-End and Back-End. The Back-End contains only
the Tables in a shared dir that all users have Read/Write access. The
Front-End contains all other Access Objects as well as linked Tables from
the Back-End. Each user should have a copy of the Front-End on his/her
desktop. This way, each user operates on his/her own copy of the Front-End
and they simply share the data in the Back-End.

Check Access Help on splitting a database.
 
Top