Missing error 3197 in multi user environment

From: Harry Barenbrug (h.barenbrug_at_hccnet.nl)
Date: 05/07/04

  • Next message: Jay Vinton: "RE: List of DAO error codes" 
    Date: Fri, 7 May 2004 18:06:35 +0200

    I am writing a multi user program in VB 5 , using DAO 3.5 (Jet) and I have
    the following problem.
    Station A reads (method Seek) a record, station B reads the same record.
    Station A changes the record ( methods Edit and Update), a little bit later
    station B also changes the record. Now I expect error 3197. But nothing
    happens. Consequently only the changes made by station B are effective.

    The database is opened as follows:

    Set MyDatabase = MyWorkSpace.OpenDatabase(CurDB, False)

    The record set is opened as folllows:

    Set MyRec = CaravanDatabase.OpenRecordset("MyTable", dbOpenTable)
    MyRec.LockEdits = True

    Is my assumption that error 3197 should be raised correct? If so, what am I
    doing wrong?

    If not , how to handle the situation of simultaneous updating?

    There is normally quite some user interaction between .Seek and .Edit, but
    no user interaction between .Edit and .Update.

    Thanks for some hints

    Harry

  • Next message: Jay Vinton: "RE: List of DAO error codes"

    Relevant Pages

    • Re: EOleException - Object was Open
      ... > try to edit a record that is already been edited in another station, ... > received a message that the record is locked, and when i try to edit any ... using Server side cursors to ... client side. ...
      (borland.public.delphi.database.ado)
    • EOleException - Object was Open
      ... In a Delphi 7 application, connecting an Access Database with ADO, after I ... try to edit a record that is already been edited in another station, ... received a message that the record is locked, and when i try to edit any ...
      (borland.public.delphi.database.ado)
    Loading