Question Logging Activity

[rookie1985]

Just a question, I am developing a database for the company I work for and being new to Access, I have successfully made a login menu when the database starts up. The employee selects there name and begins data entry. Is there any way to log the activity of each employee, which records they inputted, date and time and so on?

Have checked in Help and other online resources but no luck.

Thank you in advance.

 

[LeonDavies]

Hi rookie,

By the sounds of it your looking for some kind of audit trail for user activity so that would be a good term to search for - should be plenty of stuff on the site and google to help you out.

One method is to include the following fields in your table: created_by, created_on

The created by field is the name of the user logged on so you'll need to look the user up and then if you set the default value of the created_on field to now() it will tell you exactly when the record was created.

You can do something similar for editing records

Hope that gives you a good start - let me know if you want me to expand further and I'll dig some code out for you

 

[LeonDavies]

Theres a good link actually that may solve the issue I can't post it though but search for

Who changed the data on msaccesstips.com

 

[rookie1985]

This has been helpful, I have gone back working on other areas of the Database. I already see the direction I am going in though because of these tips.