Question about multiple users errors

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I have inhertied a database split to a back end and a front end, BE is on
a network drive and the Front end is loaded on the users C drive.
All users have been given full access to the folders.
Problem: recently it its been seen that for some reason when one user access
the database all others are locked out. This was not the situation before
other users were able to use the database at the same time, I'm not sure what
caused this problem if anyone has any ideas why this happened or how to fix
it, it would be most appreciated.
-Steve
 
Have all the users close down the database and then check to see if there is
still a .ldb file in the folder where the backend resides. If it is still
there then you have acquired a "ghost" user who is blocking others somehow.
Delete this file and all should be well again.
 
Did you add functionality that modifies objects. Access will only allow
sharing of data. Multiple users cannot share a database if they are
changing objects.
 
Thanks Lynn,
I will check that right away.

Lynn Trapp said:
Have all the users close down the database and then check to see if there is
still a .ldb file in the folder where the backend resides. If it is still
there then you have acquired a "ghost" user who is blocking others somehow.
Delete this file and all should be well again.

--

Lynn Trapp
Microsoft MVP (Access)
www.ltcomputerdesigns.com
Click to expand...
 
Back
Top