How to set concurrent multiple user access on MS Access 2003?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nie.jean@gmail.com - 23 Mar 2007 08:54 GMT

The database is on our central file server. Individual workstations
have MS Access 2003 licences. I created an access level security with
1 administrator and multiple users with differing rights (e.g. can add
records, can't delete). Current problem is that only 1 user (whether
admin or regular user) is in the database, no one else can get in to
update or even view the records. How can I change the settings to
allow concurrent access? Thanks.

Reply to this Message

Douglas J. Steele - 23 Mar 2007 12:02 GMT

Each user requires Change access (Read, Write, eXecute, Delete) to the
folder where the MDB file exists. This is because a locking file (LDB) is
created when the first user accesses the database, updated by subsequent
users, and deleted when the last user leaves the database.

BTW, do you have the database split into a front-end (containing the
queries, forms, reports, macros and modules), linked to a back-end
(containing the tables and relationships)? Only the back-end should be on
the server: each user should have his/her own copy of the front-end,
preferably on his/her hard drive.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> The database is on our central file server. Individual workstations
> have MS Access 2003 licences. I created an access level security with
[quoted text clipped - 3 lines]
> update or even view the records. How can I change the settings to
> allow concurrent access? Thanks.

Reply to this Message