Refreshing list of current users in multi-user db

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?
 
J

Jerry Whittle

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top