To log a user,set up a table with the following fields,UserID,Action,ActionDateTime. Ensure you have the user's id or name in a session e.g. session("userid")= request.Form("UserID") and then insert a record and the action that they perform like the example below.


 










 


<%

set oConn=server.createobject("adodb.connection")

oConn.open "DSN=MyDSN"




updatedate = FormatDateTime(Now,0)

sSQL = "INSERT tblUserAction (UserID,Action,ActionDateTime) VALUES ('" & session("userid") & "','Logged on','" & updatedate & "')"

oConn.Execute (sSQL) %>


 

 






                    

Copyright © 2012 VisualBuilder. All rights reserved