Re: Help with Allen Brown's (wonderful!) audit trail code.

Thank you, Allen :-). I'm not sure how to incorporate it into the audit
trail code I got from you, though. That is, I already have the code for the
other (current user, machine name, etc.) but when I try to add it to the
audit trail code, I get error messages saying something like "the input query
must have a query or table" (or something like that. So I know I'm doing
something wrong, and think it must be something really simple, but I'm not
getting it. I'm very new at this and not sure how to add to the existing
audit trail code to make it all work right.

"Allen Browne" wrote:

> The database use name is given by:
> CurrentUser()
>
> The machine name is here:
> http://www.mvps.org/access/api/api0009.htm
>
> Not sure what you mean by the network full name.
> And potentially the person could be on multiple networks?
> You could try opening a Windows command prompt, and entering:
> SET
> If you see the name there, you be able to use Environ()
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Janet" <Janet@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:877A3B18-5B48-4C74-B7CA-2C8A61AAB355@xxxxxxxxxxxxxxxx
> >I used Allen Brown's instructions for creating an audit trail. It works
> > very, very well (thank you, Allen!). It shows the type of audit,
> > date/time
> > audit occurred, and the network username of the person who inserted,
> > updated,
> > or deleted a record.
> >
> > I would like to add a few more things, though, and have no idea how to do
> > this. I want to add: 1) network full name (in addition to network
> > username),
> > database username, and machine name.
> >
> > How do I do this?
>
>
>
.

Relevant Pages

  • Re: Help with Allen Browns (wonderful!) audit trail code.
    ... You will need to add the fields to both the audit table, ... Then you will need to modify the Append query statements so they include ... > trail code I got from you, ... >>> audit occurred, and the network username of the person who inserted, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Help with Allen Browns (wonderful!) audit trail code.
    ... I'm not able to provide free support for all the free stuff at the ... > I added the following fields to both temp audit and audit tables: ... > would go in the audit trail module, ... >>> audit trail code to make it all work right. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Help with Allen Browns (wonderful!) audit trail code.
    ... Not sure what you mean by the network full name. ... >I used Allen Brown's instructions for creating an audit trail. ... > audit occurred, and the network username of the person who inserted, ... > database username, and machine name. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Holes in my security - advice needed
    ... I will be blamed if there is an attack, ... I would do a audit of the information on the network. ... If they don't understand why it is bad,...then how did the company policy ...
    (microsoft.public.windows.server.networking)
  • RE: network auditing
    ... I was just reading the thread on the "NASA security Audit" ... Port scan the target network IP. ...
    (Security-Basics)