DateModified Property maybe?

[fredalina]

i have a linked table in my database that i need to check the last date it was modified. If it was not modified today (via update tables in ITS backend database) then i need to display a warning message box warning the user that the data hasn't been updated today and allowing them to exit the procedure and update the table before trying again.

Is there a DateModified or LastModified property for the table that i can check? If so, what would be the syntax? The table name is Test 1.

Thanks!

 

[allan57]

I dont think there is property connected to a table showing when data was last updated.

You could put a field in your table to store the date when a record was added/modified and use that for your criteria.

 

[namliam]

No there is not unless you make an extra field yourself that you update yourself when a user changes anything...

 

[fredalina]

Thanks for your help.

Sigh, i was afraid of that. i really don't want to modify the other table in the other database because the person who owns it is difficult to work with on stuff like that.

There is a date field in the table (date orders were processed, etc), so perhaps i can create a query to determine the max of date or something and work around it.

Thanks!