Results 1 to 2 of 2

Thread: locking/unlocking

  1. #1
    Join Date
    Dec 1969

    Default locking/unlocking

    What do I need to do so that when I update/insert info in my database, noone else can update it at the same time??? (Basically how do I lock it?)<BR><BR>Also- what happens if userA is updating the db, and userB is trying to at the same time... does userB get an error message?<BR>Thanks!!<BR><BR>Set Conn = Server.CreateObject("ADODB.Connection")<BR>Conn.Co nnectionString = "..."<BR>Conn.Open<BR><BR>Set rs = Server.CreateObject("ADODB.Recordset")<BR>rstStr = "INSERT INTO myTable VALUES ..."<BR>rs.Open rstStr, Conn

  2. #2
    Join Date
    Dec 1969

    Default RE: locking/unlocking

    Check out the ADO recordset settings - there are different locktypes that you can use...<BR><BR>Also, use INSERT and UPDATE instead of rs.add and rs.edit...

Posting Permissions

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