Refreshing list of current users in multi-user db

  • Thread starter Thread starter Curious
  • Start date Start date
C

Curious

I try to compact and repair a backend db.
I get an error msg that user "xxx" is using the backend.
I ask "xxx" to close db.
Now I get an error msg that I am using backend and can't open backend for
exclusive access.
Error msg repeats even if I close the backend db (and all db's that may be
linked to the backend) and try again.
I can only get rid of the msg if I reboot Windows.
Is there a way to force Access to refresh the list of current users?
 
There's a little file in the same folder as the BE database with the same
name. It has either a ldb or laccdb suffix. This file keeps track of who is
in the database. This file needs to be created, modified, and deleted
dynamically. If all users don't have Read, Write, Create, and Delete
privileges to the folder holding the database, you can have the problems that
you are seeing.
 
Back
Top