How to get rid of unpleasant ldb file in MS Acess

[Guest]

Recently, every time i create a new access file only, a same name ldb file
created in the same folder. I don't share computer or change any option of MS
access. Why it happens and how to stop that fkg ldb file that? Thanks

 

[David F Cox]

Close Access.

The ldb file is a temporary file used in record locking, and is normal and
necessary whilst Access is open.

 

[J. Goddard]

You can't stop that file from being created. It will be there as long
as the database is open. If it stays there after the database is
closed, you probably have a problem with the file permissions in the
directory the database is in. Are you able to delete the file manually?

John

P.S. If 'fkg ldb' means what I think it does, kindly refrain from using
it, if you expect civil replies.

 

[Arvin Meyer [MVP]]

The ldb file is the temporary locking file that is created and destroyed
with every Access session. If the ldb file lingers after an Access session,
it means that you have crashed, or otherwise exited incorrectly.

You can keep it from being created by opening the file exclusively, or by
changing Windows permissions to disallow file creation. That also keeps
anyone else from editing the data during your session.