Re: strategy for record locking in multiuser environment

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 05/03/04

  • Next message: Brian Bushay TeamB: "Re: Looking for advice on retrieval and storage of large amounts of text" 
    Date: Sun, 02 May 2004 23:24:52 -0500

    >I am using an Access 2000 database

    >How is the best way to control record locking so that 1 user doesn't
    >overwrite another users entries and so each user can see the changes or
    >additions made by other users
    Access default is optimistic locking and it does't do pessimistic locking well
    so you probably want to stay with optimistic locking.
    Optimistic locking will give you a message when you try to save a record if
    another user has made changes to that record while you have been editing it.

    >If a user edits or adds to a record is there an event triggered within the
    >recordset or connection objects which notifies a copy of my program
    >currently open on a PC, that changes have been applied to the database
    >table?
    NO

    > I am using a CursorType = adOpenDynamic
    > LockType = adLockOptimistic
    If you are using these settings along with serverside cursor and TableDirect =
    true you will get some updating of the record when other users change it
    although it won't be immediate. 

    --
Brian Bushay (TeamB)
Bbushay@NMPLS.com
  • Next message: Brian Bushay TeamB: "Re: Looking for advice on retrieval and storage of large amounts of text"

    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: 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: "realistic" buffering?
      ... You would have to use a combination of optimistic locking and manual code to ... I want to allow another process to update fields that the current view ... With any database you would have to come up with some way of handling this outside of the database itself. ...
      (microsoft.public.fox.programmer.exchange)
    • Re: strategy for record locking in multiuser environment
      ... >>overwrite another users entries and so each user can see the changes or ... > so you probably want to stay with optimistic locking. ... > another user has made changes to that record while you have been editing ...
      (borland.public.delphi.database.ado)