US/onyx/customer-guide/images/78670.gif' alt='Microsoft Access Current Database Name For Wordpress' title='Microsoft Access Current Database Name For Wordpress' />Using Microsoft Access to remove duplicate records in a data collection Drewslair. This is a BIG topic on BIG Data, but these are Excel hints. The challenge here is saying a little, pointing you to a few indepth resources, to possibly spark. Detect time of last change on a Microsoft Access database table. The only way to detect if data in the table has changed is to perform a query against the table. You must add a column of type DATETIME to the table e. Last. Updated. Date that indicates the last updated datetime of each row. Clover Efi Drivers. Make it NOT NULL so that you will have to write an updated DATETIME value to that column for each INSERT or UPDATE. Also, set the column to have a default of DATE for the current date stamp or NOW for the current datetime stamp. Then add a Validation Rule or CHECK constraint e. CHECK Last. Updated. Date NOW to ensure the column is actually updated on each UPDATE and INSERT. Finally, run a MAXLast. Updated. Date query and you will get what you need.