1888 Articles Home | Computer Articles | Data Recovery Articles | Website Promotion Articles		Data Recovery RSS
Error “Cannot lock file ” while opening the MS Access database file

Stellar Phoenix Access Recovery is a fully-featured Access Database Repair software that repairs Access database files after almost all corruption scenarios. created in Microsoft Access 2007, 2003, XP (2002), and 2000, the read only tool can provides safe recovery of all Access database components such as tables, queries, forms, reports, macros, and modules.
Author: Colin Dolly	Article Tools:

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).

About Author

Colin Dolly is a self employed Internet entrepreneur and product reviewer. Our access recovery software completely recovers and repair access database components such as, views, tables, forms, queries, macros, etc. This access recovery application supports Access 2007, 2003, XP and 2000. For More Details:- http://www.repair-access-file.com/

Article Source: http://www.1888articles.com/author-colin-dolly-23246.html

Other Related Articles Microsoft Office SharePoint Server (MOSS) Services — A Brief Introduction by Hemal Shrimanker No debit card loans - Easy Access to Cash without debit card by David Warner Chinese Jewelry by Anirban Error “Cannot lock file ” while opening the MS Access database file by Colin Dolly Quick loans for bad credit - Facilitating Instant Borrowing by Stanley Percival Loans for adverse credit: Fast Cash Approval without Any Credit Check by Steve c clark Payday Loans: Feasible Fiscal Solution In Critical Times by Harris Vincent

Computer

Certification Tests

Data Recovery

Games

Hardware

Mobile Computing

Personal Tech

Software

All Category