ASP VBScript command object lockPessimistic

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?
tom_burkhardtAsked:
Who is Participating?
 
Data-ManConnect With a Mentor COOCommented:
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
 
Data-ManCOOCommented:
no ADO does not have a lock pessimistic property....Mike
0
 
tom_burkhardtAuthor Commented:
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
 
tom_burkhardtAuthor Commented:
Thanks!!
0
 
Data-ManCOOCommented:
Use the return value to pass back a failure...0 if it worked.

Mike
0
All Courses

From novice to tech pro — start learning today.