Results 1 to 3 of 3

Thread: Record locking in Access using ADO

  1. May 4th, 2000, 04:26 PM #1
    msdnexpert
    msdnexpert is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Nov 1999
    Posts
    266

    Angry

    How does one lock a record in Access97 using ADO and the Jet Engine?
    Reply With Quote Reply With Quote
  2. May 4th, 2000, 07:10 PM #2
    Ianpbaker
    Ianpbaker is offline
    Fanatic Member Ianpbaker's Avatar
    Join Date
    Mar 2000
    Location
    Hastings
    Posts
    696

    Smile

    Set the recordset to adLockPessimistic normally sorts out your problem

    Hope this helps

    Ian
    Yeah, well I'm gonna build my own lunar space lander! With blackjack aaaaannd Hookers! Actually, forget the space lander, and the blackjack. Ahhhh forget the whole thing!
    Reply With Quote Reply With Quote
  3. May 5th, 2000, 01:34 PM #3
    msdnexpert
    msdnexpert is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Nov 1999
    Posts
    266
    I have tried this but it does not work. In case of a multiuser scenario the record being edited is not getting locked.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width