Lock file error opening database

jul64marty

New Member
Joined
Apr 10, 2004
Messages
7
I am having a problem with a user trying to open my database, which is stored on a shared area. The user is using Windows 95, but has Ofice 2000 - the database was created in Access 2002. The user is getting the error Cannot open lock file, as soon as she double clicks the database file.

Any help would be great

Thanks

Jul
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
jul64marty,
If the database was created in 2002 and you are trying to open it in 2000, that's your problem. You need to convert the database to the 2000 format. Here's the Online help explaining how to do this.

HTH
Cal

You can convert a Microsoft Access database in Access 2000 or Access 2002 file format back to Access 97. You can also convert an Access database or an Access project in Access 2002 file format back to Access 2000 file format.
Open the Microsoft Access file that you want to convert. If it is a multiuser Access database that is located on a server or in a shared folder, make sure that no one else has it open.
Important If you have protected the Microsoft Visual Basic for Applications (VBA) code, you must supply the password before you convert the file by clicking Code on the Database toolbar and entering the password in the databasename Password dialog box.

If you are converting a secured Access database, you must have Open/Run and Open Exclusive permissions for the database itself, and Read Design permissions for all objects in the database. To secure a database that has been converted to Access 97, you must open it in Access 97 and apply user-level security.

On the Tools menu, point to Database Utilities, click Convert Database, and then click the file format you want.
In the Convert Database Into dialog box, type the name of the new previous-version database that you want to create in the File name box, and then click Save.
If the database that you are converting to Access 97 contains code, open the new database in Access 97, open a module and click References on the Tools menu, and in the Available References box, clear the check boxes next to any missing references and set a reference to the Microsoft Access DAO 3.51 Object Library.
 
Upvote 0

Forum statistics

Threads
1,221,864
Messages
6,162,497
Members
451,770
Latest member
tsalaki

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top