Add a field that records date/time to when a record was last chang

[Guest]

Hello all,

I know that you can add a property to a form that holds the date & time the
record was last updated, but I was wondering if you could add a field to a
table thet even if you go into the table itself and enter the data, it would
still update that field??

Thanks,
Mike

 

[Allen Browne]

No. Access lacks triggers, so you cannot do that in a JET table.

 

[liuwen]

Hello all,

I know that you can add a property to a form that holds the date & time the
record was last updated, but I was wondering if you could add a field to a
table thet even if you go into the table itself and enter the data, it would
still update that field??

Thanks,
Mike

erwe

 

[Rick Brandt]

Nope. Not unless the tables a link to a server database that supports triggers
like SQL Server. Access/Jet tables have no events like that.