Need a Data Recovery? - Follow the simple steps below!
Send your Hard Disk to Salvation Data, 105 Upper Lisburn Road, Belfast, BT10 0LG
Send us your Hard Drive. Make sure to include your name and address inside package.
We will Recover your Data from your PC or Mac Hard Disk for 249.99+vat within 24-72 Hours not Weeks! We offer the best value service within UK.
You verify the data via email or telephone.
We will let you decide what method you want the data backed up.
We dispatch data to you on a next day service
Our Address: Salvation Data 105 Upper Lisburn Road, Belfast BT10 0LG Email us 24x 7 at sales@salvationdata.co.uk
Error "Cannot lock file <filename>" while opening the MS Access database file
- by Colin Dolly
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 the 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.
