Microsoft Access Database: Using The Locking File (LDB or LACCDB) Within Microsoft Access

Microsoft Access Database – Latest EzineArticle Release

If you haven’t been keeping upto date with my articles from EzineArticles then checkout this one about Microsoft Access Database Locking files.

The Most Important Locking File (LDB or LACCDB) Within Microsoft Access

Have you noticed when you open an Access database that it generates another (same named) file but with a locking file extension of either an LDB (Microsoft Access 2003 or earlier) or LACCDB (Microsoft Access 2007 or later)?

This file should automatically generate and extinguish itself when opening and closing your Access database and the upshot is that you do not need to do anything with it unless you want to.

What is and Why have a locking file?

First of all it’s a safe and harmless file which rides along with your opened database file in the same location and is not a virus (as one IT trainer once tried to impress and proudly inform me!).

It’s used to keep track of one or more users who are currently working on the same database and therefore plays the role of keeping a log of multiple users with their machine name and user name.

You can view this file in a plain text editor though some editors might return odd characters (try using Microsoft Word instead of Notepad) and you will see the machine name and user name listed for members currently using the Access database file.

When the last individual closes the shared Access database, it will automatically delete the locking file (well in most cases). However, this doesn’t always delete itself and ideally you should physically delete it yourself assuring you of no harm is done.

How do I use it?

I use it in my Access database to view who is currently logged in the database should I need to manage users via different features like sending internal flags and messages to them and that’s it really as it will not be a live list of users and update quick enough.

But this file is not created when a user opens the Microsoft Access database file in exclusive mode which means they are the only person who can gain access making this file redundant.

Another Tip for you! If your locking remains visible after the last user has closed the database file, you can either delete it or better still run the Compact & Repair command which will release it for you.

I invite you to keep up to date with my articles and eBooks which covers a lot of details and can be found at https://AccessDatabaseTutorial.com.

From Ben Beitler – “Your Access Database Expert”

Article Source: http://EzineArticles.com/?expert=Ben_S_Beitler

Microsoft Access Database – My Comments

Well, not much to add really considering I wrote it! But if you want to see what the locking looks like, see the screenshot below which was opened in MS Word.

Microsoft Access Database Locking File (laccdb)

This entry was posted in Database Theory, MS Access, Utilities and tagged , , , . Bookmark the permalink.

7 Responses to Microsoft Access Database: Using The Locking File (LDB or LACCDB) Within Microsoft Access

  1. Ben says:

    ldb file is not a db file therefore you can simply delete it and it will regenerate itself when starting the mdb file again.

  2. Gowsalya shri says:

    how to unlock the ldb file.

  3. Pingback: Anonymous

  4. Guitarzan8 says:

    Sometimes a multiuser Access database will have problems and you need to have everyone close it so you can fix the problem. I use this util all the time, it’s called ldbview.exe. available in the jetutils.exe here http://support.microsoft.com/kb/176670

    there are .ldb and .laccdb access lock files. ldbview can open either, just File > Open > change the file type to all files, navigate to the folder with the .laccdb file, select and open it and voila! There’s the user who has the database open.

    From here you have to put on your troubleshooting hat, but more than likely, that user just needs to open then close that database and Access will automagically delete the lock file.

  5. Ben says:

    It depends where you want to automate your Access database? Within Microsoft Access you would use either macros or VBA code (or both toegther) attached to events namely OnLoad for a form.

  6. collins brax says:

    how can i automate access database.which software should i use to perform this task.

  7. Microsoft Office Professional Plus 2010 Key says:

    It’s really a cool and useful piece of info. I’m satisfied that you simply shared this helpful info with us. Please stay us informed like this. Thanks for sharing.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Confirm you are human.