General discussion

Locked

Multiple user access in MS Access MDB

By nancyv ·
I need to know how to modify our database system to allow for multiple staff members to be in ** comfortably ** at the same time.

Currently more than one person may go in and make changes as long as they are not on the same record. However, if someone tries to exit the database, the others have to get out too in order for the person exiting to save changes. This is affecting work flow and serves to discourage staff from doing their own updates to the database. What can I do so that we canstill have multiple staff in making changes to the database without requiring others to exit in order when each individual needs to save and logout?
We are using MS Access 97.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Multiple user access in MS Access MDB

by andrew In reply to Multiple user access in M ...

What front end are you using? Are you accessing the data directly from the Access application?

If so, I would recommend writing a front end application (either with Access forms or VB). If you use a data access library like ADO, you'll be able tomanage concurrency much more easily.

Collapse -

Multiple user access in MS Access MDB

by nancyv In reply to Multiple user access in M ...

The question was auto-closed by TechRepublic

Collapse -

Multiple user access in MS Access MDB

by donq In reply to Multiple user access in M ...

Nancy, you won't like this answer but I have built MANY database applications for higher educational institutions - and ALL failed to 1. model their original storage definitions properly.
2. normalize theor data warehouse.
3. use a central data storage "server" each authorized user had access to.
4. invest the necessary time/money to learn data modeling basics OR retain someone to define and implement a properly modeled data warehouse.

To do what you need you MUST!
1. Split a properly modeled and normalized database application (buily using any database product like Access 97) into a front-end (that fits on authorized users PCs) and a back-end (that fits on a server users are authorized to access).
2. For Access 97 set the record locking option to "Optomistic".

Collapse -

Multiple user access in MS Access MDB

by nancyv In reply to Multiple user access in M ...

The question was auto-closed by TechRepublic

Collapse -

Multiple user access in MS Access MDB

by nancyv In reply to Multiple user access in M ...

This question was auto closed due to inactivity

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums