Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

adLockPessimistic

Status
Not open for further replies.
Casiopea

Casiopea

Programmer
Joined
Jan 15, 2003
Messages
47
Location
ES
I'm using ODBC to connect to an access database; in the begining I defined the recordsets with adLockOptimistic and confirming operations with BeginTrans, CommitTrans, RollbackTrans from ADO; after that I have changed to adLockPessimistic due to concurrence in the database, and the problems have come from then. I've got the next error:
2147467259 (8004005)and it shows an ODBC error like: field cannot be used at this moment and it debugs at Begintrans; if I turn it back to adLockOptimistic again, it works, what should I do?
thanks in advance.
 
Status
Not open for further replies.

Similar threads

tb2007
  • Locked
  • Question Question
High concurrency and adLockPessimistic
Replies
1
Views
70
fredericofonseca
fredericofonseca
macl
  • Locked
  • Question Question
adLockPessimistic / adLockOptimistic
Replies
0
Views
38
macl
macl

Part and Inventory Search

Sponsor

Back
Top