Paste Errors Table (1 Viewer)

P

poison_ivy777

Guest
lady in distress - help with paste errors table

hello,

i am new here and i need some help if possible...

i am running some append queries appending to a table with defined multiple-primary key... some of the records emerge twice and as such they are deleted...

however, i would like to review records that have been deleted and there is no paste errors table... also after running the query, access displays the message with violations, but there is no usual message with pasting the records into the paste errors table...

i am not an expert in access so i would like to know if i have done something to disable putting deleted errors in paste errors table...

please help...

thanx
 
Last edited:

neileg

AWF VIP
Local time
Today, 11:21
Joined
Dec 4, 2002
Messages
5,975
You could replicate the process. Instead of appending direct to the main table, append to a temporary table, then append this table to your main table. Run a unmatched query to find the records in the temp table that have not updated in your main table.

Not elegant, but it will work.
 

Len Boorman

Back in gainfull employme
Local time
Today, 11:21
Joined
Mar 23, 2000
Messages
1,930
I think to get a paste errors table you actually have to carry out a paste operation. An Append query is not the same as a paste operation.

Len B
 
P

poison_ivy777

Guest
thnx

thank you len, this one worked...

i supposed that i was doing something wrong and now i know what...

:) :cool: ;) :)
 

Users who are viewing this thread

Top Bottom