Hello,
I have a split DB running and when I try to open the back-end to do edits on
a table, I get a message saying that I do no have exclusive access and that
my changes may not save.  When I checked the ldb files I found that there is
always two and they seem to be from the same user.  I've tried to delete them
and they do but then they show up again.

Is there anything I can do?

On Wed, 12 Jul 2006 10:13:02 -0700, Pattyt <Pat***@discussions.microsoft.com> wrote:

The .ldb file is the lockfile generated by Access whenever a user opens the database. You can delete it, but, as you've
found, Access just rebuilds it as needed. Also, you cannot delete it if another user has the db open ... Windows will
alert you and disallow the delete.

You cannot edit a table that is in use in Access 2000+. You'll have to open the db exclusively to do this ... you can do
this by opening Access, click File - Open, then locate the file and click the down arrow beside teh Open button ...
select Open Exclusive. Of course, you cannot open the file exclusively if another user already has it open.


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

Adv/disadv of using Access built-in security tools vs build in db
Network Security multiple users, Getting rid of the warning messag
corrupt files
Installed updates, now macros don't work!
Creating security for MS Access application
log in problems
deleting microsoft access user passwords
Disable Security - Use the standard .mdw file - Allow external apps to connect using DAO
Missing User data on some macros stops conversion of Access97 to Access2003
Startup problem with runtime and no-runtime apps