Discussion Locked

Access 97 error

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

Hello,

I would like to ask you for some help in resolving an error that is getting worse.

Current Status
--------------
We have an Access 97 dB over an NT server, which concurrently accessed from clients running a Visual Basic application.
The Problem
-----------
We are getting ERROR 91, which means that a record has been locked, and to free it, we have to logout (clear) *all* connected users to that .mdb, .ldb, and .exe

Please your comments will be greatly appreciated, also if you know where is it possbile to get this info please don't hesitate to let me know.

Thanks in advance,

9 replies

by dmiles

One it will happen if you are using SQL Server and it governs the database
Also you can get info from the Microsoft Knowledgebase at Q209132,and Q225926.Hope this helps.

by donq

There are two kinds of locking in Access 97 - Optomistic and Pessimistic

Optomistic locking locks a record (page) when the save begins and ends when the save is completed. Ussually less than .2 seconds per page or record (even on a slow machine).

Pessomistic locking locks a table (or recordset) when it is opened in edit mode and ends when the table (or recordset) is closed. It sounds like you may have the database locking type set to Pessimistic???

Error 91 is NOT an Access error. Access (VBA) locking errors are 3260, 3197, 3167, and 3186. Error 91 may be from your VB interface stuff???

With the database back-end closed set the setup locking option to Optomistic (or Edited Record).

by heberm70

Hi, I?ve had some troubles with shared items on Access, have you downloaded and intalled the Office97 Service Pack?

by heberm70

Hi, I?ve had some troubles with shared items on Access, have you downloaded and intalled the Office97 Service Pack?

This discussion is closed to new replies.