Multiuser problem

[Tim Lund]

This isn't really a getting started post, but that group
was unavailable. Apologies in advance if wrong to post
here instead.

I have a handful of users using a MDB file from time to
time, some directly, some via MS queries from Excel, some
creating database objects in code. All say they are not
using it now, but the .ldb file says that some are. As a
result I can't compact the database, rename it or delete
it. Why does this happen? What do I do?

Thanks in advance

Tim

 

[Michael Viescas]

The .ldb file should be deleted whenever the last active
user closes the connection to the database. If the file is
not being removed, there may be a connection termination
problem with the design of the database.

If this is the case, you should be able to simply delete
the .ldb file and then compact the db. My first suspicion
for the open connections would be the Excel interface...

HTH

-Mike

 

[Joan Wild]

Another possibility is that users do not have delete permissions on the
folder where the mdb is. Therefore, the ldb can't be deleted.