Transaction deadlock handling

See more:

VB

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