Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS Access
 Locking an open recordset
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Jóhannes
Junior Member

Iceland
139 Posts

Posted - 17 August 2010 :  08:54:49  Show Profile  Visit Jóhannes's Homepage  Send Jóhannes an AOL message
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>' ")


Please help

Jóhannes

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 17 August 2010 :  11:08:21  Show Profile
Before calling the dbcon.Execute, use
rs.Locktype=3
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.15 seconds. Powered By: Snitz Forums 2000 Version 3.4.07