Can I Find out when a TABLE was MODIFIED ?

  • Thread starter Thread starter sam1967
  • Start date Start date
S

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 ?
 
is there any way to find out the date and time a Table was
last modified ?
Click to expand...

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).
 
John Vinson said:
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).
Click to expand...

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.
 
Um, John, that's how to determine the last time data in
the table was modified ...
Click to expand...
I think that was what John was guessing from the O.P.'s
question. FWIW, I am guessing the same way.

Cheers
Van
 
Van T. Dinh said:
I think that was what John was guessing from the O.P.'s
question. FWIW, I am guessing the same way.
Click to expand...

Yeah, going back and rereading the question, you could be right.
 
Um, John, that's how to determine the last time data in the table was
modified, not the table itself.
Click to expand...
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.
 
Back
Top