Show results of action query?

[rsmccli]

Hello, using Access 2002.

I was wondering if someone knows a way to show the results of an append or update query.

When you run, let's say, an Append Query, Access notifies you that 10 records are about to be appended. Then Access says that only 8 were appended because of key or index rule problems. Is there a way to have Access show either which records were appended or which records were unable to be appended?

I figure that you could run a select query before hand to view the 10 records that are about to be appended, but this would not help with what I am trying to do.

Thanks for the help.

rsmccli

[Stewart Ross]

Hi. I don't know of any way to check for all such failures in advance of running an update query. Reason that such failures occur is (1) the data is not in line with relational constraints (e.g. appending would lead to duplicate primary key values, or there is no matching one-side key value if the append is on the many-side table); (2) one or more of the values appended is not permissible given the data type of the field concerned; (3) one or more of the values is of a permissible type but violates a validation rule or range constraint for the table.

Through suitable queries it is possible to check for duplicates or widowed many-side records in advance (situation 1), but the same is not true for situations (2) and (3).

-Stewart