Hi all I want to open a recordset from a web page using ASP and Access DB. But I want to lock the recordset while i'ts open. How do I do that? How do I lock the recordset so no other user can edit it while I have it open?
This is the code I'm using:
Set dbcon=server.createobject("adodb.connection")
dburl = Server.MapPath("/<something>")
dbcon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & dburl
Set rs = dbcon.Execute("Select * From TBL_ASK where ID like '<something>' ")
Search is your friend “I was having a mildly paranoid day, mostly due to the fact that the mad priest lady from over the river had taken to nailing weasels to my front door again.”
Locking an open recordset
Topic Locked
Posted - 17 August 2010 : 08:52:16
