Action Query: List specific records/columns that violate index or validation
When running an action query, if records will be 'excluded' due to index or validation, give clear info as to what records & columns are causing the issue.
Ben Sacheri commented
I'm out of votes but I would like to have more descriptive error message that tells what column I should focus on.
Anders Ebro (TheSmileyCoder) commented
This has been one of the really strong features of access, that when you do imports, you get the import errors table, and when you try to copy-paste records, you get a paste error table.
This works soooo much better than when you try to do imports through e.g. SSMS, and just get a simple message saying "the import has failed".
It would be nice if this feature could be extended to action querys.