Securing Form Entries

[JonTarg]

I notice that it is possible to secure entire databases to prevent certain
users from changing any values in it.

It is all too easy to change a value in the record by accident, however I
have not come across a method to protect against this in Access.

If authorized users unintentionally change a value in a record when querying
the database either by table or form, can Access settings be applied that
notify the user(s) that the record has been changed and question him/her as
to whether that change should be saved.

Furthermore is there a feature in Access, which tracks changes to individual
records, stating what changes were made when and by whom? Can this
information be displayed on a query form?



----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...50a26009c&dg=microsoft.public.access.security

 

[Tom van Stiphout]

On Sun, 22 Mar 2009 05:15:01 -0700, JonTarg

You can setup a form such that the record is locked (AllowEdits and
its cousins set to False) until the user clicks an Unlock button.

You can also write code in Form_BeforeUpdate asking the user if the
data needs to be saved (and set Cancel=True if not). I would find this
highly annoying, but ymmv.

No, such audit trail does not exist as a built-in feature, but
googling for it may find you some hints on how to write custom code.

-Tom.
Microsoft Access MVP

 

[JonTarg]

That's a big help, thanks.

On Sun, 22 Mar 2009 05:15:01 -0700, JonTarg

You can setup a form such that the record is locked (AllowEdits and
its cousins set to False) until the user clicks an Unlock button.

You can also write code in Form_BeforeUpdate asking the user if the
data needs to be saved (and set Cancel=True if not). I would find this
highly annoying, but ymmv.

No, such audit trail does not exist as a built-in feature, but
googling for it may find you some hints on how to write custom code.

-Tom.
Microsoft Access MVP