Unanswered: How can I "log" when a user loads an ASP?
I have a sql server 2000 database, accessed via some data access pages developed using Access 2000. I would like to be able to "log" which user and when loaded the said pages, that is to be able to perform a triger-like action such as:
Insert into logtable (Page_accessed, User, time)
select 'Mypagename', current_user, getdate()
What changes should I make to my data access page?
Yes, write the code to insert the information into the database (perhaps the username is stored in a session variable, etc.). And perhaps put this code in a function in an included file. And of course call the function at the top of each page: