Discussion Locked

ACCESS file locking

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have an access file which I cannot copy or export. Get message you and another user are attempting to change same data. No other users are on the system. This is error # 3197. Any help would be appreciated.

7 replies

by raffi_

Hello.

Is the application using ODBC? If so then please advise (but you can try the following anyway)

Exit the application and then do a search for any files called *.ldb. This is the Access network control file. Delete it. Access is supposed to create a new one each time you start the db. Sounds like it isn't or there are a couple of them floating around.

Then open Access by itself and select the Tools > Database Utilities > Compact and Repair Database from the menu. Select your database and allow Access to repair it.

In most cases the above steps will fix the problem.

Regards
Raffi_

by spankil

Hi,
You can do the following,
Open .ldb file in a Note Pad which is a text File. you can See the Computer Name and User Name Who Access the File. Find it Out who had open the File and Close it From there.

If no body had open it. Just Open the file from the Computer it(*.ldb) has specified and Close it Properly.

Then try to do whatever you wants to do.

Regards
Pankil.

by angsax

Is this a file on a network? Which version of ACCESS. 2000 needs a change in Tools - Advanced to NOT open databases locked (uncheck box). Author can set rules for sharing (permissions et cetera).

This discussion is closed to new replies.