Table modify date not changing after exporting data into another database tbl

[gdesreu]

Hi,

I have some VBA that dumps data from one database into another database into a specific table, however after it dumps the data, the modify date on the table I am dumping it to does not update. Is there a way to trigger this date modified if you are dumping in the data from another database? This date is extremely important for tracking purposes.
Thanks

 

[Joe4]

I would probably go about this a different way.
I would add a new field to your table, something like "AddedDate". Then your process which dumps the data into the table, have it update this field to the current date/time. Then you will not only be able to know when the table was last modified, but when each record was actually added.

And you could use a simple Aggregate Query to get the date of the last update, i.e.

SELECT Max(DateAdded) AS LatestAddedDate
FROM MyTable;

 

[gdesreu]

I would probably go about this a different way.
I would add a new field to your table, something like "AddedDate". Then your process which dumps the data into the table, have it update this field to the current date/time. Then you will not only be able to know when the table was last modified, but when each record was actually added.

And you could use a simple Aggregate Query to get the date of the last update, i.e.

SELECT Max(DateAdded) AS LatestAddedDate
FROM MyTable;

Thanks this was my backup plan, but the issue is many of our DB users look at the modified date for reference in our systems to ensure they have the right version of the data so I was hoping to figure out how to trigger the modified date as if it were a local table. Otherwise I will have to tear apart a lot of export functions.

 

[Joe4]

Note that if you are talking about the Modified date on the table, that refers to the Table structure, not the Table data.
Updating data in that table, regardless of how it was done (import, manually, update query, etc) will NOT affect that date.
Only changing the Table structure/design will update that date.

So if you are trying to capture when data was last added to the table, you do NOT want to use this date (you are using the wrong field for the job!).

You can see this pretty easily. Check the Modified date on the table. Now add a data record to that table manually. Now go back and check the Modified date. You will see it has not changed.

 

[gdesreu]

Note that if you are talking about the Modified date on the table, that refers to the Table structure, not the Table data.
Updating data in that table, regardless of how it was done (import, manually, update query, etc) will NOT affect that date.
Only changing the Table structure/design will update that date.

So if you are trying to capture when data was last added to the table, you do NOT want to use this date (you are using the wrong field for the job!).

You can see this pretty easily. Check the Modified date on the table. Now add a data record to that table manually. Now go back and check the Modified date. You will see it has not changed.

Thanks a lot that is good to know!!!