ldb

[O Wilson]

Hello,

I'm an Access dabbler that has come across a problem with an .ldb file. A
database I created was recently moved to a new, company machine and now, when
I open it, it freezes up. I see an ldb file has been created, but it never
goes away. If I delete it, but it just reappears the next time I open the
database. It stays after the database is closed (which I have to do with the
task manager because it is frozen solid) What is causing this and how can I
stop it?

TIA

 

[Van T. Dinh]

An LDB file (locking file) is always created whenever the database is opened
normally. The LDB file is automatically deleted when the database is closed
normally. The problem is that if you end the process, Access cannot delete
the LDB file for you.

You may need also delete permission on files in the folder where the MDB
file resides so that Access can delete the LDB file using your permission.

If Access freezes up when you open the database (after deleting the LDB
file), the problem is somewhere else ...

Try deleting the LDB file then holding the Shift key down while you are
opening the database ... You may have some problems with the Startup options
....

BTW, you should always post the OS + Access version and service pack number
.... to make it easier for readers to analyze your specific situation ...

 

[John Vinson]

Hello,

I'm an Access dabbler that has come across a problem with an .ldb file. A
database I created was recently moved to a new, company machine and now, when
I open it, it freezes up. I see an ldb file has been created, but it never
goes away. If I delete it, but it just reappears the next time I open the
database. It stays after the database is closed (which I have to do with the
task manager because it is frozen solid) What is causing this and how can I
stop it?

TIA

The first thing to check is the user's permissions on the folder
containing the database. To use the database, you must have FULL
create, read, write and delete privileges on the folder. My guess is
that the account you're using to log onto Windows does not have Delete
privileges in this folder.

John W. Vinson[MVP]

 

[Jeff Boyce]

You don't mention which version of Access you are using. Older (much
older!) versions created an .ldb file and never deleted it. With the
freezing up, it seems more likely that, as others have suggested, the
permissions on the share are insufficient.

Regards

Jeff Boyce
<Office/Access MVP>