Hello

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?

THX

Marp

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:

' Pg entry log.
Call PgEntryLog()