I am developing an application using VB5.0 and SQl Server 6.5. I need some help inorder to implement locks. In most of the master entry screens i am updating the table using RDO resultsets.In transaction entry screens, i am either using Stored procedures or RDO query statement to do the same task. In the first scenario i don't thing locking is a big issue but for second scenario i am realy not
sure about how to implement locks.

Considering the above mentioned issues, Please help me in making my application a multi-user one. Though i have not tested it in multi-user environment i feel these issues are going to come later.