User Logging System

[GraemeG]

Hello,

I have a form which runs before the database opens which is basically a login screen.

It is a username and password system. Based upon a table called Users.

I was wondering if there was something to log when a user has been in and what they have been looking at I.e tables and forms reports etc and what date and time.
Also is this possible to extract itself every week then refresh the log?

Thanks

[ajetrumpet]

Yes, you can log this stuff. you can write the info to any table you want.

[clarkej]

theres two ways you can do it (that i know of)

in the log in screen you can tell it to write to another table "afterupdate = Date" etc to a second table this will record who entered. (i've seen this one never programed it though so maybe someone on here will be able to help you)

the version i do is a Module which sees the current user (via their PC logon) and then in the tables i want to have have amendments logged i have a feild "userid" and its "default value" is =CurrUser

using the Moduel and a staff table list this can then pull in the users name (or depending on what way you have it set up) it then records it in that table.

if you want an example of modual code let me know and i'll dig it out for you