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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top