Hey All,

I'm writing a simple transaction database for my team using VB6 and ADO. I've never written a db app for multiple people before, so I have a question.

When a user opens a record and a second user tries to open the same record, I want to display a message to the second user that the record is being edited and to try again later.

From the FAQ, I see that both adLockOptimistic and adLockPessimistic will notify me when a second user tries to edit the record, but I'm interpreting it that the error won't occur until I do a command that actually changes a field in the record.

How do I see if a record is opened for editing BEFORE allowing the second user to open it at all? Is there a standard way to do this?

If this isn't clear, let me know. I'll be glad to expand and/or try again with the wording of my question.

Thanks much,
Bret Reece