Question Multiple users access

[seangarb]

Hi

I have been asked to develope a simple database, which I am happy i can do with no real problems. The problem is the database will be used by multiple users, possibly at the same time.

Is there a way that this could be done in MS Access? i need a way to get around the fact that when one user opens the database, it becomes read only to other users and becomes unreliable.

The database can be stored on a global drive if that helps?

thanks

Sean

 

[georgedwilkinson]

This can be done. You need to split the database into a Front End/Back End arrangement. You would store the Back End (where the tables are located) on a network drive, as you suggested.

Each user would get a unique copy of the Front End on their own machine. You can use a tool like Bob Larson's free FE updating tool to keep the Front End copies up to date.