Creating an audit trail

[Mike1500]

Hello All,

I have a form in an intranet environment and I'm wondering how I can create an
audit trail. The information I want to track is listed below. Please let me
know how i can perform this task. Any advice would be greatly appreciated.
Thanks.

- UserID of the person who submitted the form
- The time the form was submitted

Operating System: Windows 2000
Language: ASP
Database: SQL Server

[CarlGrint]

You do not mention if the users are logged in and if so how they are logged in.

If you yours log in first, then you can simply add a hidden field and assign
the UserID from your recordset, filtered on the login username.

Regarding the time, simply set the Date/Time column in SQL server to have the
default value of getdate() and the database will do this for you.

If you can let us know the way your users are logging in we should be able to
give you more information regarding the UserID.


Originally posted by: Mike1500
Hello All,

I have a form in an intranet environment and I'm wondering how I can create an
audit trail. The information I want to track is listed below. Please let me
know how i can perform this task. Any advice would be greatly appreciated.
Thanks.

- UserID of the person who submitted the form
- The time the form was submitted

Operating System: Windows 2000
Language: ASP
Database: SQL Server

[Mike1500]

Thanks for the quick response CarlGrint, the users will be logged in via
Windows Authentication. The way the form is now anyone could view submit an
entry, which I would like to change if possible. Thanks.

[Mike1500]

Thanks for the quick response CarlGrint, the users will be logged in via
Windows Authentication. The way the form is now anyone could view submit an
entry, which I would like to change if possible. Thanks.

[CarlGrint]

If they log in via Windows auth, then you are only at the best going to be able
to grab the username they have logged in as, no ID number wise.

I believe their is a way to grab this, if you search this forum I have seen a
number of question and answer on this subject.

Originally posted by: Mike1500
Thanks for the quick response CarlGrint, the users will be logged in via
Windows Authentication. The way the form is now anyone could view submit an
entry, which I would like to change if possible. Thanks.