Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2002
    Posts
    192

    Unanswered: SQL Server and Access record locking

    I have an Access front end. The back end are sql server tables. Does this mess up the way Access locks records? for example, when i set both the form and database to lock edited records, i can still edit a record on computer 2 after i've changed but not saved the same record from computer 1.

  2. #2
    Join Date
    Dec 2001
    Location
    Toronto, Canada
    Posts
    335
    My understand of the senario is:

    1) Computer 2 reads record (shared lock)
    2) Computer 2 has record,viewable in Access (no lock)
    3) Computer 1 reads record (shared lock)
    4) Computer 1 has record,viewable in Access (no lock)
    5) Computer 1 update record (update lock)
    6) Computer 2 update record over writes computer 1 changes(update lock)

    You will need to implement your own logic if you wish computer 2 to maintain a lock on a record while view to prevent computer 1 from reading and changing.

    This is not a good idea if computer 2 reads obtains lockout and then goes for a break or answer a phone call. You would need to implement timestamps maybe.
    MCDBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •