Locking an open recordset - Posted (1127 Views)
Junior Member
Jóhannes
Posts: 139
139
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:
Code:
  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>' ")

Please help
Jóhannes

 Sort direction, for dates DESC means newest first  
 Page size 
Posted
Advanced Member
Carefree
Posts: 4224
4224
Don't post duplicate messages.

http://forum.snitz.com/forum/topic.asp?TOPIC_ID=69673
Posted
Support Moderator
Shaggy
Posts: 6780
6780
Locked.
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.”