title: QueryTimeout Expired Error when SELECT after UPDATE statement run in same ADODB transaction
body: <p>Mine is Ms access linked with mySql database</p>
  
  <p>Query Timeout Error occur </p>
  
  <p>-begin ADODB transaction
  -1st update statement run
  -2nd retrieve that updated record . &lt;---- Alert error in that stage.
  -commit ADODB transaction</p>
  
  <p>!Update and select run on same table and same record.
  !I don't want to commit between 1st and 2nd.</p>
  
  <p>I think that record locked after updated. I want to unlock it from access VBA if my thought is right. If not Please help !</p>