Re: locking in ADO

From: Susan Leigh (magine_at_turtleflight.com)
Date: 02/21/04

  • Next message: Susan Leigh: "Re: locking in ADO" 
    Date: Fri, 20 Feb 2004 21:08:18 -0500

    No, Optimistic locking. As far as I know (and intend) all the database
    access is serial...no new operation should begin before any previous one
    is done.

    Brian Bushay TeamB wrote:
    >>The errors I'm seeing are either:
    >>
    >>Could not update, currently locked by used 'admin' on machine 'TORTUGA'
    >>
    >>(Tortuga is the computer's name.)
    >>
    >>OR
    >>
    >>Row cannot be located for updating, some values may have changed since
    >>it was last read.
    >>
    >>Is this a matter of trying to change too many records in rapid
    >>succession?
    >
    >
    > No. The second Error occurs when ADO can not find the record in your dataset in
    > the database to update it. The default is to use all the field values from when
    > the record was retrieved. Your fields no long match what is in the database.
    > I have never seen the first error you are getting. Are you trying to use
    > pessimistic locking or do you have a transaction open?
    > --
    > Brian Bushay (TeamB)
    > Bbushay@NMPLS.com

  • Next message: Susan Leigh: "Re: locking in ADO"

    Relevant Pages

    • Re: Informix beats Oracle
      ... program outside the database, whereas it's my impression that Oracle folks ... Oracle simply because it's a lot different than most. ... To me optimistic locking is an entirely different beast and Informix had support for it for years and DB2 Viper 2 is introducing it. ... You look for a seat going from A->B and you get a set of possibilities back. ...
      (comp.databases.informix)
    • RE: Error Message
      ... I do need help with Optimistic Locking -- thanks again. ... > Your database is corrupt. ... More than one user opening and using an Access database file ... which we use to log in and track incoming jobs. ...
      (microsoft.public.access.formscoding)
    • Re: Create Database in MS Access. & set properties of fields.
      ... Brian Bushay TeamB wrote: ... Access is the only database I know that supports the Allow Zero length property. ... Catalog1. ...
      (borland.public.delphi.database.ado)
    • Re: Record currently locked - 3218
      ... Have you split this database, so that each user has their own separate copy ... of the front end (program mde), all connected to the same back end data mdb? ... containers, we get the conflict. ... With optimistic locking, the record is locked only during the write ...
      (microsoft.public.access.modulesdaovba)
    • Re: strategy for record locking in multiuser environment
      ... >overwrite another users entries and so each user can see the changes or ... Access default is optimistic locking and it does't do pessimistic locking well ... that changes have been applied to the database ...
      (borland.public.delphi.database.ado)