MS Access table modified date [RESOLVED]
I am trying to get the table modified (or creation) date of a table in Access. I am pulling in sales data and storing current sales in a table, which is overwritten with new sales the next day. On the form I display the sales numbers, I need to show when the sales were last updated. I could get this information dynamically from the sales table's creation/modified date property; however, I cannot find a way that works for me.
Ideally, I want the code that gets this information to run during the Form_Load() event.
Any thoughts?
