What's the .ldb file do?

  • Thread starter Thread starter el zorro
  • Start date Start date
E

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?
 
What's the purpose of that little .ldb file,
Click to expand...

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?
Click to expand...

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?
Click to expand...

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
 
Back
Top