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

[nie.jean]

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.

 

[Douglas J. Steele]

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.