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.ConnectionString = "..." <BR>Conn.Open <BR><BR>Set rs = Server.CreateObject("ADODB.Recordset") <BR>rstStr = "INSERT INTO myTable VALUES ..." <BR>rs.Open rstStr, Conn