LDB files
Under most circumstances, when you use an Access database, a ldb (Locking DataBase) file is created in the same directory as the database itself, and has an extension ldb instead of mdb. The exception to this is when the database is opened read-only and exclusively. Normally, this file is deleted when the last user quits the database. This means that if you need to check whether the database is currently in use, you can check for the existence of this file. You can also open this file using Notepad, and see the names of the computers that are currently using the database.
Sometimes the ldb file is not deleted when a database is closed - normally when the database is corrupt or the last user to exit the database doesn't have delete privileges on the folder where the database (and hence the ldb file) is located. This can lead to problems, as Access will believe that there is at least one user of the database, and will start to produce strange error messages. To fix this, just ensure that there isn't anybody actually using the database, and then delete the ldb file.
Top
HOME |
NEW |
TABLES |
QUERIES |
FORMS |
REPORTS |
GENERAL |
API |
DOWNLOADS |
TUTORIAL |
RESOURCES
E-MAIL
Copyright & Disclaimer
| 
