I recall in my Paradox days that when appending records to a table or
updating records and data type conflicts or key violations were
automatically placed in tables called "Problem" or "Key_Viol". This was
very helpful in that Paradox performed the requested action while making a
table showing those records which were not included in the requested action
due to some type of conflict. The "Problems" or "Key Violators" could be
seen, analyzed and fixed just by viewing the table. I've been around
MSAccess (A97-XP) for a few years now and haven't seen anything comparable
to this great Paradox feature. When presented with a conflict, MSAccess
provides a 'Warning' that it did not add 'this many records for this reason
and did not add that many records for that reason and so on and so on', but
will not display the affected records. Similarly, Paradox had a "Subtract"
records function which would place the 'Subtracted' records in their own
'Subtracted' table. The closest thing to this that I've seen in Access is
the "Delete" query which does not automatically produce a table of the
subtracted (Deleted) records. Does anyone here know if MSAccess has a
similar feature or some "wizard" that will produce the same result in either
case?
TIA...
Earl Anderson