Solved

ASP VBScript command object lockPessimistic

Posted on 2004-09-21
5
244 Views
Last Modified: 2012-06-21
I'm using a command object to pass 35 parameters to an Access database stored procedure, using the ".Execute" command. Does the command object not have a lockPessimistic property the way a recordset does?
0
Comment
Question by:tom_burkhardt
  • 3
  • 2
5 Comments
 
LVL 18

Expert Comment

by:Data-Man
ID: 12117093
no ADO does not have a lock pessimistic property....Mike
0
 

Author Comment

by:tom_burkhardt
ID: 12117267
thanks. I didn't think so. Any idea what happens if someone else makes a change at the same time? There must some default read type/lock type for the command object (I'm using an implicit connection, rather than going through a connect object).
0
 
LVL 18

Accepted Solution

by:
Data-Man earned 200 total points
ID: 12117342
I usually send over the timestamp field and compare that to the current timestamp to ensure that the record hasn't changed before doing the update.

Mike
0
 

Author Comment

by:tom_burkhardt
ID: 12117380
Thanks!!
0
 
LVL 18

Expert Comment

by:Data-Man
ID: 12117434
Use the return value to pass back a failure...0 if it worked.

Mike
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question