Dear Pros,

Im a Visual Basic Programmer with experience of about 12 years. I do my application using VB as front end and Oracle as back end. However, i had never deployed in a highly concurrent enivironment where many users use the application at the same time. I am in the process of implementing but have got challenges as the application keep on throwing errors and not completing the transactions. The following are the Errors that are frequently thrown which i suspect are as a result of Concurrency request:

"cannot update row as the data in the database has changed"
"cannot delete row as data in the database has changed"

This is how im connecting to my DB

If RsCoin.State = 1 Then
RsCoin.Close
End If
CmdCoin = "SELECT * FROM COINAGER WHERE ACCNO='" & CoinSt & "'"
RsCoin.Open CmdCoin, ConACExp, adOpenStatic, adLockOptimistic

RsCoin is a recordset

Can somebody assist me how to solve this problem?