Software

Ask something
Discussion Locked

Access 97 Error 3186

0 helpful
7 replies

by arotondi

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I can't seem to get rid of this error. The database is "shared". All of the tables, queries, etc. have no locks on the RecordLock property. Have tried playing with the settings on the advanced tab of the options/tools with no avail.

The person locking doesn't even have to be adding a record for it to lock, they just have to be in the database.

Help?

7 replies

by don christner

Look at Q122958, even though it talks about Visual Basic, I believe that it applies. Specifically, look at the first paragraph of the More Info section.

Don

by stillatit

In Access help, read the section on LockEdits Property. You probably have pessimestic locking set, which means that you are locking a 2K block whenever you look at a record.

Good luck.

by donq

At EACH MACHINE (if already distributed) seect Tools | Options | Advanced (tab) and in the Default Record Locking box click the option you want! - "Optomistic"

This discussion is closed to new replies.