• Around The HomeToggle Menu

    • Entertainment
    • Productivity
    • Smart Home
  • FamilyToggle Menu

    • Parenting
    • Toys
    • Pets
    • Travel
  • ReviewsToggle Menu

    • Phones
    • Tablets
    • Laptops
    • Desktops
    • Wearables
    • Audio
    • Cameras
    • Headphones
    • Printers
    • Smart Home
    • TVs
    • Gaming and Video
  • One Cool ThingToggle Menu

    • Frugal Tech
    • Kickstarters
    • Videos
  1. Home
  2. Around The Home
  3. Productivity
  4. How Do I Unlock a Microsoft Access Database?

How Do I Unlock a Microsoft Access Database?

By: Jenny Hansen
  • Share
  • Share on Facebook

Every version of Microsoft Access uses a locking file that prevents users from working on the same record at the same time. Microsoft Access 2013 databases have a file extension of ACCDB. When you open a database file, Access creates a locking file with the LACCDB extension. The purpose of this file is to prevent multiple database users from updating the same record at the same time. The LACCDB file contains no data and deletes itself when you close the database. However, in some cases, this file does not delete itself, and the database continues to show as locked.

Security lock that is locking a Folder
Locked files waste precious time.
credit: Qstockmedia/iStock/Getty Images

The Access Record-Locking File

Since version 2007, the default Access file extension is ACCDB. Locking files share the same name and location as the main database file, but their extension is LACCDB. Before the 2007 version, these extensions were MDB and LDB.

Video of the Day

The LACCDB file remains open until the last user exits the database. In rare cases, this locking file does not delete itself and must be removed manually. If you know the name of the database, but do not know where it is stored, you have two options: run a search for all files with the LACCDB extension, or contact your network administrators and give them the necessary information.

Show Comments

Related Articles

How to Open an LBL File

How to Open an LBL File

Around The Home
Productivity
By: Jim Campbell
How to Open DB Files

How to Open DB Files

Around The Home
Productivity
By: demand13783
How to Copy a Microsoft Access Database

How to Copy a Microsoft Access Database

Around The Home
Productivity
By: DaveB
Disadvantages of File System Data Management

Disadvantages of File System Data Management

Around The Home
Productivity
By: G.S. Jackson
How to Force Windows to Delete a File

How to Force Windows to Delete a File

Around The Home
Productivity
By: AllenBethea
Characteristics of a Hierarchical Data Model

Characteristics of a Hierarchical Data Model

Around The Home
Productivity
By: Warren Davies
  • HOW WE SCORE
  • ABOUT US
  • CONTACT US
  • TERMS
  • PRIVACY POLICY
  • COPYRIGHT POLICY
  • Advertise

An error occurred. Try again later.

Thanks for signing up!
© 2019 Leaf Group Ltd. Leaf Group Media

Get great tech advice delivered to your inbox.

Keep your family productive, connected, entertained, and safe.

Please enter a valid email.