Lock with Access

Results 1 to 2 of 2

Thread: Lock with Access

  1. #1
    Join Date
    Dec 1969

    Default Lock with Access

    I have a JScript asp page that updates a record in the database. I want to lock it, so that two people can&#039;t update the record at the same time. <BR><BR>I opne the records set with adOpenDynamic, adLockOptimistic and try updating using IE and NS at the same time. No error prevents the second from overwriting the first.<BR><BR>So, I try adLockPessimistic, etc., but nothing works. Does anybody know what is wrong?<BR><BR>thanks for any help!<BR><BR>jon

  2. #2
    Join Date
    Dec 1969

    Default RE: Lock with Access

    I think what you&#039;re trying to say is :<BR><BR>"I want to lock a record when a user begins editing it." <BR><BR>this is not built-in to asp/ado - you&#039;d have to write a custom system to do it. ADO locking only takes effect when ADO is actiualy accessing the record, i.e. not in the edit page.<BR><BR>j

Posting Permissions

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