How to track edits in a table?

[erumhyder]

I want to track edits made in table ABC in the past week from today.
Is there a function in Access ( my database is access) that can tell me the date any of the existing/new records in the table have been edited?
Thanks

[missinglinq]

No, you'd have to handle this thru VBA code. Hopefully you're not allowing data entry directly into the table but rather thru a form. You'll need to add a Date/Time field to your underlying table, named something like DateEdited. Place this field on your form. If you don't want it visible to the user, set its Visible Property to No. Now place this code in the form's code module.

For Date only:

Private Sub Form_BeforeUpdate(Cancel As Integer)
  Me.DateEdited = Date
End Sub

For Date and Time

Private Sub Form_BeforeUpdate(Cancel As Integer)
  Me.DateEdited = Now
End Sub

Linq ;0)>

[NeoPa]

The short answer is that "No - Access doesn't maintain any such level of logging of your changes".

Should you decide that you wish to go to the trouble of implementing this feature yourself, then Linq's post will get you started in the right direction.

Welcome to Bytes!

[MindBender77]

Neopa and Linq are most certainly correct.

It really depends to what extent of tracking you wish to achieve but, you can have Access export log files daily. This is done entirely through vba from a form linked to a table. I have incorporated this with several of my projects. You could view minute to minute actions of your users if you wish.

If you decide to go this route let me know and I will provide a snippet to get you started.

Bender