Results 1 to 3 of 3

Thread: multiuser database lock

  1. May 8th, 2007, 06:36 AM #1
    muhannad
    muhannad is offline

    Thread Starter
    Member
    Join Date
    Nov 2006
    Location
    Jerusalem
    Posts
    39

    multiuser database lock

    hi, can anyone please help me with this..

    i have an adodc with two text boxes attached to the employees table in northwind (sqlserver) .

    I want to update a certain row .. then when another user logs in and tries to update the same row I want to lock it (not by using a boolean field indicating if its locked or not)
    i.e. is there a method in the connection, recordset, .. that allows me to lock some rows or tables in my database. . thank you in advance.
    Reply With Quote Reply With Quote
  2. May 8th, 2007, 08:41 AM #2
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: multiuser database lock

    Moved
    Reply With Quote Reply With Quote
  3. May 8th, 2007, 01:47 PM #3
    randem
    randem is offline
    Banned randem's Avatar
    Join Date
    Oct 2002
    Location
    Maui, Hawaii
    Posts
    11,385

    Re: multiuser database lock

    Try this example it will help you Concurrency Checking
    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