Modified Date in a Table (1 Viewer)

teric2 said:

Is there a way to have a modified date field in a table that would update any time a particular record was edited in any way?
I have a backend with several front ends linked to it and want to know whenever someone changes data in any of the fields of a record. Is there a way to set something in a fields properties in the design of the table to do this?

Click to expand...

jdraw said:

Do all changes to records occur through Forms?
Can you post a copy of a sample (representative) database-- just enough data to show the kind of info? Remove anything private.

You might get some ideas from this post on Audit Trail, but it is more extensive than your current requirement.

Click to expand...

HiTechCoach said:

Access has added a data macros to eh AACE/ACCDB format. I have not tried them but it might do what you want at the table level.

See:

https://msdn.microsoft.com/en-us/library/office/ff973807(v=office.14).aspx

Click to expand...

teric2 said:

I'll take a look at this.
Thanks for responding.

Click to expand...