I am Inserting data from a table1 to table2 using INSERT INTO SELECT with MS ACCESS 2007, However I want to add a time stamp in table 2 in which I added a field called deleted on, to know when the record was deleted. Need Urgent Help ? Anyone Help me Pls ?
-
-
If you mean you want to do this through a database trigger, the Access database engine has no trigger functionality. If you mean, through a form, then you can use VBA code in an event to capture when it happens in a form. However, this does not cover every possible way a user has at their disposal to delete data.
Comment