How to create a log table in Access

[Marco Silva]

Hi. I want to create a log file into a table in Access. Well, it also can be
into a txt file, but I think into a access table would be better.

My idea is to register any step that a user make in access. Imagine this, is
he changes a record, it records into the log, if he create, he register, if
he delete a record, it record.

The I would made a report to that tabela and I could see what each user have
done.

Is it possible?

Marco

 

[Allen Browne]

Access lacks triggers, so there is no way to log actions on the table.

But in most serious Access applications, all activity happens in forms, and
you don't let the user anywhere near the tables themselves. If that's how
your application works, you can use the events of the form to create the log
entries.

For details, see:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html

You will need some experience with VBA code to achieve this.