Click here to Skip to main content
15,877,675 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I do 2 select stmts and an insert stament in a module of my vb application. hence if a single user executes there isnt any problem, but if multiple user uses it gives transaction deadlock error.

rs.Open strQ, cnn, adOpenKeyset, adLockReadOnly

it uses the above stm in the select.
How should i modify to avoid this transaction deadlock error which raises when multiple users try to access the same module. Pls help

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900