info ADD/DELETE query

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

Is it possible to get info when I changed a table with a ADD or DELETE
query?
I would like to have a sort of logbook so I always can see when a table has
been updated.
I hope somebody can help me out.

Thanks anyway
Rob
 
Access doesn't have audit trail so you need to write your own VBA code if
you want some sort of trace. So, you need to run the Query via VBA code and
not the GUI. In addition, you can only record that the Query has been
executed, not each affected Record.

Perhaps, you should check out MS-SQL Server or MSDE.
 
Hi Rob, at this point ,I'm only familiar with, if the table has a bound form, On the BeforeUpdate event of the form, I have a field that defaults to the current date Date(). This is a VBA function. So in the VBE window between the procedure stub for the forms BeforeUpdate event, I would write, Me.txtUpdated.Value = Date
This though, only gives the date a change was made, edit , delete, newrecord etc.. even a typo correction
It's not very explicit, but does offer some indication of action going on, within each record
Hope this offers some insight, good luck!
 
Van T. Dinh said:
Access doesn't have audit trail so you need to write your own VBA code if
you want some sort of trace. So, you need to run the Query via VBA code and
not the GUI. In addition, you can only record that the Query has been
executed, not each affected Record.

Perhaps, you should check out MS-SQL Server or MSDE.
Click to expand...

Thans for your reply
Here is stops for me, I don't know how to write that VBA code
 
Back
Top