Re: User Tracking in Access

I haven't used it, but a quick perusal... He says to "copy this code" to a
new module. If you search that code for logerror, you'll find 5 statements
like

Call LogError(....
Just put an apostrophe at the beginning of these lines.


--
Joan Wild
Microsoft Access MVP

Secret Squirrel wrote:
> Ok I've followed the instructions from the link you gave me but I'm a
> little unclear what he means by removing the 4 references to the
> function "LogError()". Can you shed some light on how I remove these
> and where they are located?
>
> "Joan Wild" wrote:
>
>> You might want to study what Allen Browne has on this.
>> Creating an Audit Log
>> http://www.allenbrowne.com/AppAudit.html
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>>
>> Secret Squirrel wrote:
>>> How would I link this new tracking table to the table I want to
>>> track?
>>>
>>> "Keith W" wrote:
>>>
>>>> "Secret Squirrel" <secretsquirrel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote
>>>> in message
>>>> news:47C20040-7199-470F-B7C1-AE6196E446F9@xxxxxxxxxxxxxxxx
>>>>> Keith,
>>>>> What if I wanted to expand this to show user tracking for each
>>>>> field? Can I
>>>>> create another table to keep this information? If so, how would I
>>>>> go about that?
>>>>>
>>>>> "Keith" wrote:
>>>>>
>>>>
>>>> Yes, create a new table with fields for time stamps, user ID,
>>>> record ID and old and new values. You'd then need to use the
>>>> before/after update events on your forms to trigger the recording
>>>> of the data. It's not a two minute job though.
>>>>
>>>> Regards,
>>>> Keith.
>>>> www.keithwilby.com


.

Relevant Pages

  • Re: require password for certain field entries
    ... "Joan Wild" wrote: ... > Secret Squirrel wrote: ... >>> Hide the control unless the specified user is using the form. ... >>> Microsoft Access MVP ...
    (microsoft.public.access.security)
  • Re: Securing BackEnd DB file
    ... Your instructions on the website worked great! ... Thx ... > Joan Wild ... > Microsoft Access MVP ...
    (microsoft.public.access.security)
  • Re: More security questions
    ... Joan Wild ... Microsoft Access MVP ... have permissions to do anything. ... Usernames/passwords/group membership are stored in the mdw. ...
    (microsoft.public.access.security)
  • Re: More security questions
    ... Joan Wild ... Microsoft Access MVP ... have permissions to do anything. ... Usernames/passwords/group membership are stored in the mdw. ...
    (microsoft.public.access.security)
  • Re: Database Secuirty
    ... Microsoft Access MVP ... Lori A. Pong ... "Joan Wild" wrote: ...
    (microsoft.public.access.security)