dealing with multi-user access to and pop-up alert message

3

3colorcat

I have set up different user accouts with logon names and
passwords in the database in Access 97. I find
difficulties in developing security functions for the
following scenario.

I want to prevent one user from editing/deleting records
which another user is already working with and both of
them will receive a pop-up message alerting about such
event.

Visual Basic is not available in the computers of my
office. Can I solely write VBA in Access to implement
these functions? May any one suggest some reference about
VBA to tackle this problem? I am just a beginner of VBA.
Thank you!
 
Top