Retrieve date modified of a table

[TimE]

Is it possible to retrieve the date modified from a table? The table in question is updated from numerous sources and I would like to display the date on a form/report so the users know how old the data is.

 

[DJkarl]

Is it possible to retrieve the date modified from a table? The table in question is updated from numerous sources and I would like to display the date on a form/report so the users know how old the data is.

Currentdb.TableDefs ("YourTableHere").LastUpdated

Would give you the Modified date of a table.

However I would be careful if you plan on using this as the source to tell when your data was last updated. I have a table that's updated daily and has a last modified date of September 30th 2005.

If you really need the information to be accurate I would suggest a date or time stamp field in the table thats added in at the same time the data is added.

 

[TimE]

Thank you for the quick response. I reviewed the table and it appears it is actually deleted and recreated every morning (if the owner remembers). The modified and create dates are the same. The data itself is not updated throughtout the day, it is only an export for multiple users to review. I wanted to display the date so they new how old it was.

One other problem(?) I did not mention. If it is a linked table, it only shows the dates when it was linked, so I would guess I need to point the code to the table using the UNC I am guessing?

 

[The_Doc_Man]

With the added knowledge that the table is linked, I think the ONLY thing that makes sense is if there is an update-date field in the table itself. Otherwise you are at the mercy of whatever is on the other side of the link.

This is where the "Old Programmer's Rules" become relevant: Access won't tell you anything you didn't tell it first.

If you want a date of last update for something, store it. That's the only way you will KNOW that Access has the date of last update.

 

[TimE]

Thank you for your help. I will see if the owner of the table will add a date field and update it each time.