Hello!

I am working with an mulituser application written in VB 4.0 (both 16
and 32 bit), with the Jet databaseengine.

I run with the optimistic locking scheme (The record is locked only in
the update process). After an update, the record (or page) don't seem
to be unlocked. I know that the unlocking is a background process, but
I also have included the DBEngine.Idle method after the update method.

Here is a sample of my code:
   tblMyTable.Edit
   'change some database fields
   tblMyTable.Update
   DBEngine.Idle dbFreeLocks

When other users access other records in the database meny seconds
after the update, the error message 3186 (the record is in use of
another user or something like that) occur.

Can someone help me? Feel  free to send me a mail!

Ulf Erik Forsbakk

        Try using FREELOCKS

_
******************************************************************
NOTE: This software is currently in early alpha. If you notice any

Please do not report duplicates, as this is usually a manual resend
+------------------------------------------------------------+


|Physically in Church Hill, TN - Logically Not Sure          |
+------------------------------------------------------------+

**Special Compile: 3.000A (Alpha)

Thanks!

Hasn't FREELOCKS and DBEngine.Idle dbFreeLocks the same functionality.
I think FREELOCKS is a Jet 2.0 thing. However my application seems to
work now. I have included a timer control in my main form, which
periodically runs DBEngine.Idle dbFreeLocks. I thought that a JET
table was locked only between the edit/addnew and update methods. It
seems to be locked during seeks and other operations as well. Is this
right?

Ulf Erik Forsbakk

In VB4 16bit I found that 1 user (or program) doing a FIND operation
on a recordset prevents other users from doing ADDNEWs. Strangely, it
did not prevent other users from doing EDITs (even to the same record
as the one returned by the FIND).

Storing and reusing bookmarks did not prevent ADDNEWs.

Andy Stedman