Record user logons(time,date) in the Database.

[suseli]

I have created a ASP login page for the users in Dreamweaver. Username and password are saved in the MS Access Database. Is there anyway that i can record the user's logons time and date in the database. For eg if userx logons the username, time & date will be saved in the database.

 

[ChrisHirst]

Yep as a continuous log or just the last instance ?



Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[suseli]

Please can you tell me how can i do it in Dreamweaver?

 

[ChrisHirst]

possibly

but which?


Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[Cheech]

As ChrisHirst is trying to tell you you can either insert a new record into another table using the userID & Now() this will maintain a log of when the users have logged in or just update a field in the user table with Now() to show the last logged in date/time

Cheech

[Peace][Pipe]

 

[suseli]

I not only the last instance but all the logins been made by the user.

 

[Cheech]

Then just insert a new record into a seperate table that captures the user ID and has a column set up with a default value of Now()

[Peace][Pipe]