What's the .ldb file do?

[el zorro]

What's the purpose of that little .ldb file, and what
happens if I delete it in a multi user (FE on
workstation -BE on server) environment? If I copy
the .mdb file without the the .ldb file, does anything
bad happen?

 

[Guest]

Basically, the .ldb file keeps track of security and who's using an Access
database in a multi-user situation.

For more information, take a look at:

Introduction to .ldb files
http://support.microsoft.com/default.aspx?scid=kb;en-us;299373

Hope that helps!

DBS (David Staas)

 

[John Vinson]

What's the purpose of that little .ldb file,

It keeps track of "record locks", identifying which users have which
records open on a database. Normally Access will create a .ldb file
when it's needed and delete it when the last user closes Access.

and what
happens if I delete it in a multi user (FE on
workstation -BE on server) environment?

You won't be able to if anyone is currently in the database (and if
you did succeed it would probably mess their Access session up
bigtime).

If I copy
the .mdb file without the the .ldb file, does anything
bad happen?

Nope. Access will just create a new one. However, copying an open .mdb
file is a recipe for disaster; if you copy it while someone is
updating, it's very likely that the copy will be corrupt.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps