Append Function Help

[alicey]

I have two replicated Access database, one is splitted and the other is not. I tried to use the 'Append' function to append data from one db to the splitted db, I receive this msq: duplicate output destination, can anyone tell me how to use the Append function, pls.

 

[alicey]

The other error meq that I receive is:
set 0 fields to null due to a type conversion failure, it didn¡¦t add 357 records to the table due to key violations, 0 records due to lock violations and 0 records due to validation rule violations.
pls help. Thanks.

 

[VBACT]

One possibility for this error is that by appending to the table you are creating duplicated values in a field that does not allow duplicates. Another posssibilty is that you may be appending data into field that have different field characteristics.

Let me know

 

[Fubear]

As stated above - check your key fields and make sure your not duplicating data.

I would also think that the duplicate output error has to do with the field names you are appending to.

EG: You have two tables, TableA and TableB, both have an ID field. If you say 'Insert into ID' (not proper SQL i know), it is getting confused as to which ID field you have selected, or you have an output field named 'ID: NZ(ID,0)' which could also confuse it.

Also you will probably want two queries, one to insert new records (your append query), and another to update existing records (an update query suprisingly enough).