Problems with splitting a database

  • Thread starter Thread starter Mandi S
  • Start date Start date
M

Mandi S

I have a database I would like to split between 5 users. I have tried
splitting with the wizard and splitting the database manually. I have placed
the BE in a network file and I have created the FE linking to those tables.
This is where I have the problem. All my users have used that FE and saved it
to their personal pcs. They can enter the FE and input information. However,
when more than one tries to work at one time they recieve an error message
saying that the FE cannot be opened but cause the BE file is in use!
 
When you connect to a Jet database, a locking file (.ldb) is created in the
folder where the database is located. Make sure that all your users have the
ability to update files created by other users in that folder. If they
don't, then they'll be locked out.
 
Sounds like a Windows permission issue. Make sure that all users have
sufficient Windows permissions on the folder where the BE is located.
They need read/write/create/delete permissions.

Delete isn't absolutely necessary, but will make your life easier.

Joan Wild
MS Access MVP
 
Thanks Douglas. You are right, when the database is open I can see the
locking file. How do I make sure my users have the abilities you are
suggesting? Sorry I am new at this
 
The permissions problem really has nothing to do with Access. The easiest
way to test would be to have User A use Notepad to create a text document in
that folder, and then see whether User B can open that text document, make
changes to it and then save those changes.
 
Back
Top