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.
 
Is there a way that a report can display the last edit date of the database?

No, not unless you record that bit of information in some table.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top