ldb

[Marty]

I have an .ldb locking file that is locked open. When I
try to repair or compact the associated .mdb I get an
error that says it is open by pcid ... which always turns
out to be me.

I can't delete the .ldb - it says there is a sharing
violation.

1) What causes this
2) How can I fix it

Any help is much appreciated

Thanks

Marty

 

[Ron Hinds]

I have an .ldb locking file that is locked open. When I
try to repair or compact the associated .mdb I get an
error that says it is open by pcid ... which always turns
out to be me.

I can't delete the .ldb - it says there is a sharing
violation.

1) What causes this
2) How can I fix it

Any help is much appreciated

Thanks

Marty

Close the app first then delete the .LDB file. That should fix the sharing
violation. If you're still having a problem running Compact or Repair, the
db may be corrupt. Create a new, blank database. Then import the tables and
data from the original.

 

[david epsom dot com dot au]

In a network situation, the network can get confused
if something crashes on your workstation, and fails
to unlock a file. If that is the case, it will time
out if you log out and leave it overnight, or you
can log into the server as an administrator and
unlock the file.

(david)

 

[Denise]

When importing, do you mean to use File\Import steps?
I've read to export to comma delimited and then import.

 

[Marty]

Thanks, I'll try the administrator approach as logging out
and leaving it overnight (which has worked in the past)
didn't work this time.

Marty

 

[Ron Hinds]

I just use the File/Import. So far, it has worked for me. In an extreme
situation you may have to go the CSV route...