locked record removal

G

Guest

I have an extensive networked Dbase that has somehow gotten a small glich
that shows it has a locked record open. I need to remove that so I can edit
and sync the data that is in the Dbase. Any Ideas?
 
S

Scott McDaniel

I have an extensive networked Dbase that has somehow gotten a small glich
that shows it has a locked record open. I need to remove that so I can edit
and sync the data that is in the Dbase. Any Ideas?

Do you mean a DBase database? Or do you mean an Access database?

If you're referring to Access, then you need to locate the .ldb file (the locking file) for the database and delete
that. This is normally created in the same folder as the database; using Explorer, search for a file with the .ldb
extension and try to delete it ... if you can't it may mean that someone still has the database open, in which case
you'd need to determine who that is and log them out.

You can somewhat "read" the .ldb file by opening it in Notepad ... it's not 100% effective, but may give you some clues
as to who has it open.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
 

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