Can I Find out when a TABLE was MODIFIED ?

[sam1967]

The modified date and time is updated whenever I change the design of
the table. However when I update the table the modified date is
unchanged, is there any way to find out the date and time a Table was
last modified ?

 

[John Vinson]

is there any way to find out the date and time a Table was
last modified ?

No, not builtin to Access. You would need to add a Date/Time field to
the table itself (TimeModified) and update it to Now() in the Form's
BeforeUpdate event. You would also need to take steps to ensure that
the Form is the ONLY way a user can modify data in the table; if they
can open a table datasheet, there is no way to update this timestamp
(or even to prevent them from changing a timestamp to whatever date
they wish).

 

[Douglas J. Steele]

No, not builtin to Access. You would need to add a Date/Time field to
the table itself (TimeModified) and update it to Now() in the Form's
BeforeUpdate event. You would also need to take steps to ensure that
the Form is the ONLY way a user can modify data in the table; if they
can open a table datasheet, there is no way to update this timestamp
(or even to prevent them from changing a timestamp to whatever date
they wish).

Um, John, that's how to determine the last time data in the table was
modified, not the table itself.

I've heard that there's a problem with the TableDef object's LastUpdated
field in Access 2002. Afraid I don't know of any workaround.

 

[Van T. Dinh]

Um, John, that's how to determine the last time data in
the table was modified ...

I think that was what John was guessing from the O.P.'s
question. FWIW, I am guessing the same way.

Cheers
Van

 

[Douglas J. Steele]

I think that was what John was guessing from the O.P.'s
question. FWIW, I am guessing the same way.

Yeah, going back and rereading the question, you could be right.

 

[sam1967]

Um, John, that's how to determine the last time data in the table was
modified, not the table itself.

That's what i was asking. How to find out when data was last
added/updated in the table.

Maybe I didn't word it very well.

 

[SAC]

I've also found this audit trail code from Allen Browne to be helpful:

http://users.bigpond.net.au/abrowne1/AppAudit.html