Access User Tracking

[FriQenstein]

Greetings all,

My company is using Office 2016. I'm designing a database for inventory/asset management for us to utilize.
What I'd like to try to find out is if there is a way to track/log the users that input data.

For instance, if Sammy is entering new items into the database, I'd like it to be noted somewhere that Sammy was logged in and entered these certain asset records into the database.
Same for the other users.

Is there a way of doing that type of accountability for database entry?

Thanks.
Regards.

[Gicu]

You could add a field to your asset table (CreatedBy) and populate it on the BeforeInsert or BeforeUpdate event of the data-entry form or if you need more details search the forums for audit trail.

Cheers,
Vlad

[ssanfu]

It sounds like you are talking about creating an audit log. See Creating an Audit Log by Allen Browne