>
>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/community/en-us/default.mspx?mid=c900a943-4cc8-4e9b-8372-a4150a26009c&dg=microsoft.public.access.security

"Tom van Stiphout" wrote:

> On Sun, 22 Mar 2009 05:15:01 -0700, JonTarg
> <JonT***@discussions.microsoft.com> wrote:
>
> 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
>
>
> >
> >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 an individual record by accident, however I
> >have not come across a method to protect against this in Access.
> >
> >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/community/en-us/default.mspx?mid=c900a943-4cc8-4e9b-8372-a4150a26009c&dg=microsoft.public.access.security
>