Forum Discussion
Microsoft Access Giving error, File is already in use ,if access by more than people on shared netwo
Thanks for help!!!!!
Based on your question on another forum, I infer that your group may also be trying to use a single accdb stored in a network location. If that is the case, then you will, no doubt, continue to experience problems with or without the fix to this particular bug.
To be shared safely, an Access relational database application must be split into two components:
An accdb containing ONLY the tables.
An accdb containing the interface objects such as forms, reports and VBA, along with the queries.
The accdb containing tables, commonly referred to as the "Back End" or BE, is stored on a network location where it can be shared by all users.
The master copy of accdb containing the interface objects, commonly referred to as the "Front End" or FE, is stored safely in a location only the developer can reach. COPIES of the FE are placed on the computers of all users--each user gets their own copy.
All FEs link to the tables in the BE.
This is the only proper method of sharing an Access relational database application among a group of two or more users.