VB recordlocking

I am trying to implement a program that keeps track of issues in the Qa department.

I am interested in recordlocking. The program needs to allow all users to read the issues(one by one) by use of navigation buttons that fill in the data from the SQL 2k database to the controls on the form AND lock the records currently being viewed by each user. I do not know how all of this works, and if someone could give me some tutalage I would appreciate it. I am using ADO. Is there any more info you need from me?

well, in ADO, when you open a recordset, one of the properties of the recordset is a locktype. There are several types, adLockUnspecified leaves the lock open, unless rules higher in the hierarchy override that. adLockPessimistic locks the records as soon as it is encountered by a user (or refuses the record if another user is accessing it). adLockOptimistic allows multiple users to access a record at the same time. There are others, such as adLockBatchOptimistic and adLockBatchPessmistic, but quite frankly, I never use them.

thanks, but i know that already...i was looking more of a real world example that i could build around....basically i also want to return this status to the users, so they know that the record they are looking at is locked and they dont try to update it i want it to be intuitive

OK.. I see. So let me ask you this. Are you wanting to return some type of GUI interface whenever a user successfully opens a record, and therefore locks that record, or whenever a user attempts to open a record and cannot because the records is locked by another user? Or both?