Error cannot Lock File While Opening The Ms Access Database File

Microsoft Access database saved on a server can be accessed by all the client computers connected in the network

. These clients with assigned privileges can also modify the records saved in the database. However, there is a possibility that these clients may not be able to open the Access database file (ACCDB or MDB) due to various reasons like, Access database file damage, new locks implied, and more. In such situations, the data stored in the file becomes inaccessible. For absolute recovery of data in such situations, an easy way is to restore the data from an updated backup. However, if you have not maintained any database backup or backup is unable to restore the desired records, then you will need to use an advanced access repair software.

As a practical instance, you have an Access database (Accounts) saved on the server. However, when you attempt to open the database file, the below error message pops up:

Cannot lock file

The error message does not allow you to open the Accounts database file and further makes all the records inaccessible. Additionally, you receive the same error message each time you attempt to open the database file.

Cause:

Few main causes for the above error message are discussed below:

Accounts database crashed out (corrupted)

You have no read/write privileges on the Accounts database

Resolution:

In case of no read/write privileges, you will need to request the administrator to assign you the privileges. However, in case of Access database corruption, you will need to use an inbuilt repair utility known as Compact and Repair. You will need to take the below steps to use the repair utility:

1.Select Database Utilities under Tools drop down list. Click Compact and Repair Database.

2.Click Compact after searching and selecting the database in the Database to Compact From dialog box.

3.Select a new folder location for the file in the Compact Database Into dialog box.

4.Provide a unique name to the file. Click on Save.

In case, the Accounts database remains corrupted even after using the repair utility, then you will need to use a powerful Access Recovery software. Such access database repair tools are built with rich graphical user interface and use high end scanning methods to repair the corrupted Access database files (.accdb and .mdb).

by: colindolly

POST COMMENT

'the Backed Up Data Is Corrupt Or Incomplete' Error Restoring From Bkf File Data Recovery For Computers Windows Doesn't Boot If You Use Multi() Syntax In Boot.ini File Fixing Cd Dvd Game Disc Scratches Oil rises to near $79 on strong US growth data The Basics Of Your Recovery After A Hysterectomy - A Step By Step Guide Dbf Repair Tool Data Recovery Services Recovering Photos From Sandisk Ultra Ii Outlook Prompts To Start In Safe Mode Undelete Digital Camera Photos Data Centers and What They Mean to Your Hosting Account Edb Corruption Prevents You To Mount Database After Restoring From Online Backup