Finding out the last time data was updated

[k0r54]

Hi,

I am using this code below to retrieve the last updated time on the tablea.

lbl_DataLastUpdated.Caption = "Data last updated: - " & Format(CurrentDb.TableDefs("ATM_Info").LastUpdated, "dd/mm/yyyy hh:mm")

This works but the problem i have is, when i add an entry via a form or do anything else via a form. This does not get updated?. I check the properties of the table and that isn't either.

When i then modify something manually in the table (go in and change it). It then updates.

Is there something im doing wrong or is there a better way to check the last updated.

Thanks
k0r54

 

[ColinEssex]

Do a search for Audit Trail its been covered loads of times.

Col

 

[k0r54]

Many thanks

 

[ghudson]

lbl_DataLastUpdated.Caption = "Data last updated: - " & Format(CurrentDb.TableDefs("ATM_Info").LastUpdated, "dd/mm/yyyy hh:mm")

As mentioned you need to implement an Audit Trail.

The SQL you are using above will only tell you when the design of the table has been modified.