General discussion

Locked

Access database file reports file in use

By twhite ·
A MS Access dayabase file being used by 2 users (never simultaneously) resides on a network share. The file now reports that it is in use by another user and can only be opened in read only. The file is not in use and each users workstation (NT4SP5 running MS Office 97) has been rebooted. I copied the file to my desktop and it still reports the same. I even took ownership of the file. I then installed Office 2000 and could open the file after converting it to a 2000 file, but now some of the tables do not function. I have tried all of the database rebuild tools in Access, and none work.

This conversation is currently closed to new comments.

9 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access database file reports file in use

by MikeDale In reply to Access database file repo ...

Sorry, I am having the exact problem except on a novell network.

I am interested in the answer.

Mike

Collapse -

Access database file reports file in use

by twhite In reply to Access database file repo ...

The question was auto-closed by TechRepublic

Collapse -

Access database file reports file in use

by waifoon In reply to Access database file repo ...

Did you try to reboot the machine where the database is? Hopefully that helps.

Collapse -

Access database file reports file in use

by twhite In reply to Access database file repo ...

The question was auto-closed by TechRepublic

Collapse -

Access database file reports file in use

by Inspectorclave In reply to Access database file repo ...

Here are a couple of options. First, make sure that the database is set to "shared" and not "exclusive". This setting can be found by click on the Tools menu, selecting Options, clicking on the Advanced tab, and looking under the "Default Open Mode" box.

Also, if a user opens a database and for some reason the computer locks up or the user is forced to reboot the computer while still in the database, the .ldb file will sometimes not be deleted. Open up Explorer and go to the directory where the database is located and see if you see a file called <database_name>.ldb located there. If so, delete it. Make sure that you DON'T delete the <database_name>.mdb, as this is the database itself. Email me at chrisp@metronational.com if thoseoptions don't work.

Collapse -

Access database file reports file in use

by twhite In reply to Access database file repo ...

The question was auto-closed by TechRepublic

Collapse -

Access database file reports file in use

by acwiz In reply to Access database file repo ...

Sometimes in Access 97 the locking file (LDB)does not automatically delete when the user exits the database. When you get the error use Explorer and browse to the location of the network data file and delete the LDB file. It will have the same nameas the database but will end in LDB. Be sure the network database is version 8.0 and not 2.0 since it never deletes the LDB. Good luck.

Collapse -

Access database file reports file in use

by twhite In reply to Access database file repo ...

The question was auto-closed by TechRepublic

Collapse -

Access database file reports file in use

by twhite In reply to Access database file repo ...

This question was auto closed due to inactivity

Back to Software Forum
9 total posts (Page 1 of 1)  

Related Discussions

Related Forums