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?
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>' ")