Report to display last edit date of db

  • Thread starter Thread starter Nona
  • Start date Start date
N

Nona

Is there a way that a report can display the last edit date of the database?

Thanks in advance for your help.
 
Define "last edit date".

If you're asking the last time data was changed in the database, Access
doesn't capture that information. You'd need to add it to your tables and
capture it yourself.
 
You need to create a table to record edit date(s). You could append a
record with default of =Date() or Now() using macro named Autoexec and
condition that record not exist for current date so as not to duplicate.
Or an append run when you click a command button on your edit forms.
 
Back
Top