Skip to content
Sign in
Artwork for Computer Learning Zone
Computer Learning Zone · August 4 · 23 min

How to Check Whether Your Microsoft Access Back End Is Still in Use

Before compacting a shared Microsoft Access back end, restoring a backup, or changing table designs, it helps to know whether anyone is still connected. A small Access lock file can provide a quick warning that the database may be in use. Richard Rost explains what LACCDB and LDB lock files do, why they are useful in split databases, and why their presence is not always proof that someone is actively working. A crash, lost network connection, or powered-off workstation can leave behind a stale lock file. You'll also hear about a simple VBA approach for checking whether a back-end lock file exists, along with an important caveat for unbound startup forms that may not touch linked tables immediately. It is a practical way to avoid turning routine maintenance into a very interesting Tuesday.

0:00-23:34
Play in

transcript

No transcript — this publisher did not publish one.

show notes

Before compacting a shared Microsoft Access back end, restoring a backup, or changing table designs, it helps to know whether anyone is still connected. A small Access lock file can provide a quick warning that the database may be in use.

Richard Rost explains what LACCDB and LDB lock files do, why they are useful in split databases, and why their presence is not always proof that someone is actively working. A crash, lost network connection, or powered-off workstation can leave behind a stale lock file.

You'll also hear about a simple VBA approach for checking whether a back-end lock file exists, along with an important caveat for unbound startup forms that may not touch linked tables immediately. It is a practical way to avoid turning routine maintenance into a very interesting Tuesday.

more episodes

All episodes