Tracking Updates to Tables

  • Thread starter Thread starter Karrie
  • Start date Start date
K

Karrie

Is there a way to have a field in a table automatically
update with a date/time stamp when someone modifies the
record?

I know there is a way to do this if you are using a form
to access your data, but due to many circumstances (time)
we have some databases where we work in the tables.

Thanks!

Karrie
 
Karrie

In Access tables, no. (the short answer)

Also, tables give you no events and little control. Forms and form controls
give you a host of events and significant control over what/how data is
entered/updated. Consider forcing the use of a form, rather than allowing
table data entry.

If the backend is in SQL-Server or other heavy-duty db, look into
"triggers".

Good luck

Jeff Boyce
<Access MVP>
 
What you could do, however, is make a datasheet view form and add two table
fields:
_DateAdded: set in table default value = Date() (format showing date + time)
_DateChanged: add in the form's afterUpdate event: Me!_DateChange = Date()
this is very minimal, but might already provide what you need. If you want, I
think you can delete the controls referencing to these fields from the form as
well, to avoid any confusion for the users.

Hans, Belgium

Jeff Boyce schreef:
 
Back
Top