If I add a column to an access table (column 10) and I have an existing array of record ID’s from an excel vba process, what would be the protocol for updating those specific records in that column. I want to mark those records to exclude them from the next search of that access table.
I assume that this is better practice than deleting the records although the record is passed to another table so deleting original is an option.
Any pointers appreciated
Bookmarks