check history

[fajita]

Would like to check history on who, when and how long
users access the database. is there a way to set
something up to find this information maybe once or twice
a week?

 

[Rebecca Riordan]

You'll need to trap the information and store it yourself. You'd have to
make the users manually log on and off...


--
Rebecca Riordan, MVP

Seeing Data: Designing User Interfaces
Designing Relational Database Systems, 2nd Edition
www.awprofessional.com

Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step
www.microsoft.com/mspress

 

[fajita]

The users are signing in with user name and password. But
there isn't a log off, they just close it out. How do we
trap the information....? Please be more specific.

 

[Rebecca Riordan]

You'll need to create a table to store the information, and then as part of
the log on, add a record to store the user name and time. As part of the
(new) log off, you find the record and add the log off time.

HTH
--
Rebecca Riordan, MVP

Seeing Data: Designing User Interfaces
Designing Relational Database Systems, 2nd Edition
www.awprofessional.com

Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step
www.microsoft.com/mspress