Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Display "Record Locked" Message

Status
Not open for further replies.

pnsmack

Programmer
Feb 12, 2002
12
US
Good Afternoon All,

Is there any way in MS Access 2000 to display a message to the user when they have accessed a record that is currently "locked" ?

As of now, I have record locking for a form set to "Edited Record" only, and when a user loads a record into a form that another user is currently editing, all they get is a beeping/bell sound when they try to change data (which, I presume, is the indicator that the record is "read only" ?)

My question : Is there some way to pop up a message that says "Current Record is Locked by another user and is read only"....or something to that effect ?

Thanks !
Paul
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top