A simple Audit Trail (hoping)

[REBBROWN]

Hey all,
I am hoping there can be an easy way to accomplish this.
Before I go into it, let me make clear that the DB I am creating will be used by a user with Access 2007, not 2010.
If they were using 2012 I believe that is some new kind of Macro that could be used.
Bottom line I need a stripped down, simple Audit trail.



I found one but it is overkill, here is the link for it

http://allenbrowne.com/AppAudit.html

Here is what I have done so far:
I have this in a query

USER: fOSUserName()

It captures the name but here is the problem I found, it's not really logging the user name in a table, only displaying it.
I put in a bunch of dummy records to test all the functions and it says all those records were input by "User1". Then I created another login on my Windows 7 laptop and called it "User2".
You guessed it, not it seems that all those records were input by "User2".
I don't care about delete, edit, only add.
I need it to capture and store the Windows user that input the record.
How is a relatively easy way to accomplish this?
any and all help very much appreciated

[orange]

What exactly do you want to log? Only after we know that can we determine what is overkill.
Here's another audit log from Martin Green.

[ItsMe]

Sometimes I will use a form to append a record. I usually disable the Navigation Buttons in cases like this and the form opens in data entry mode. Other times, I will use an action query to append records. Another approach is to use VBA and DAO to append records.

I would identify where and how records are being appended and populate the appropriate field with the user ID at the time a record is appended.

[alansidman]

this is another resource http://www.datawright.com.au/access_..._in_access.htm

[REBBROWN]

THANK YOU !
This worked

http://www.datawright.com.au/access_..._in_access.htm

I don't care about changes or deletes, just logging who puts in the record.
Thanks again