I have an Access 2007 DB that has an Admin menu. On the admin menu I have macro buttons that will delete and update tables.
I have created a table "tbl_Uploads" with two fields. The first field lists all the tables that get updated. The second field is called "Timestamp".
How do I use the Run SQL to update the timestamp field for a given table listed in the tbl_Uploads.
DoCmd.RunSQL "UPDATE tbl_Uploads SET tbl_Uploads.timestamp = DATE()"