Notifying user read only

[Briansmi1116]

Hello everyone. I have a database that is shared on a nnetwork. There are occasional times that two people are editing the same record at the same time. This causes a problem because only one person can save the info that they entered. I want to notify the user that someone is editing the record before the other user starts their edit.

I think I have to use: objRecordset.Ed itMode, but I am unsure how. I would be greatly apprciative of anyone that could help me with this.

Thank you,

Brian

[MindBender77]

With a little Googling. I found this. Hope this helps.

ADO vs DAO pessimistic locking

Regards,
Bender

[Briansmi1116]

Thank you, but I am having trouble on where and how to implement it. I gues it only makes a little sense.

Brian

[Briansmi1116]

I found something else that will work for my application. Thank you for looking and helping me.

Brian