Feedback by UserVoice

I suggest you ...

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.

3 votes
Vote
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
You have left! (?) (thinking…)
Aaron Kogan shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • Anders Ebro (TheSmileyCoder) commented  ·   ·  Flag as inappropriate

    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.

Feedback and Knowledge Base