Home    Post Archive    RSS    Contact    Search

Marketplace

Locking File Box

Locking File BoxError "Unable to lock the file" while opening the MS Access database file

Microsoft Access database stored on a server can be accessed by all client computers connected to the network. These customers - with assigned privileges - can also edit the records stored in the database. However, it is possible that these clients may not be able to open the Access database (MDB or ACCDB) for various reasons such as, prevent access file database, new locks implicit and more. In such situations, the data stored in the file becomes inaccessible. For absolute data recovery in such situations, one easy way is to restore data from a current backup. However, if you do not update a database backup or backup is not able to restore the records you want, then you will need to use an advanced access repair software.

As a practical example, you have an Access database (accounts) stored on the server. However, when you try to open the file database, below error message appears:

"Could not lock file"

The error message does not allow you to open the file database of accounts and all records still inaccessible. In addition, you receive the same error message every time you try to open the file database.

Cause:

Few major causes of the error message above are discussed below:

  • database accounts fell (corrupted)

  • You do not read / write database accounts

Resolution:

If no read / write, you should ask the administrator to grant you privileges. However, in cases of corruption Access database, you must use a repair utility built known as "Compact and Repair." You'll need to take steps below to use the repair utility:

  1. Select Database Utilities under Tools in the dropdown. Click Compact and Repair Database.

  2. Click on Compact after searching and selecting the database in the "basis of data from Compact dialog.

  3. Choose a new folder location for the file in the "in" dialog box compact database.

  4. Give a unique name for the file. Click Save.

In this case, the database accounts remains corrupt, even after you use the repair utility, then you will need to use a powerful recovery software to access. This Access database repair tools are graphical user interface built with advanced and end-use, high scanning methods to repair files corrupted Access database (. accdb and. mdb).

Posted on July 26, 2010.
Share |

Comments

There are no comments.

Leave a Comment

Your Name
Your Email
Comments
Human Check. Type 5493.

Most Recent
Water Safety Tips
Lockbox Solutions
Imei Lock
Panasonic 920p
Polarized Safety Glasses
Cpu Lock
Dual Brite
Video Surveillance Laws

My Friends
Kitchen Forest
Home Big
Law Blog
Owners Mortgage
Realestate Abode
Property Banter
Fitness Vine
Sport Excite
Sporting Ware
Dash Sport
Sport Gal
The Sp-ort Network