Locking an open recordset - نوشته شده در (1123 Views)
Junior Member
Jóhannes
مطلب: 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

 پیش‌فرض مرتب‌سازی برای تاریخ DESC به معنی جدیدترین است  
 تعداد در صفحه 
نوشته شده در
Advanced Member
Carefree
مطلب: 4224
4224
Don't post duplicate messages.

http://forum.snitz.com/forum/topic.asp?TOPIC_ID=69673
نوشته شده در
Support Moderator
Shaggy
مطلب: 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.”