Append to master replication table

[Kurt]

For some reason I cannot use an append query to append records to a
design master replication table that has the index key on a random Long
Integer. I checked all the text fields in the Master Replication table
to make sure the properties are appropriately set as
Required: No and Allow Zero Length: Yes. Also no violation of unique
indexes.

The Access error message says can't append all the records,
....didn't add 1576 records to the table due to key violations...

INSERT INTO tblMasterRepl ( tblspecies_ID, tblCounty_ID, StatusCo )
SELECT FWS.SpeciesID, FWS.CountyID, FWS.STATUS
FROM FWS
WHERE (((FWS.Match)=F alse));

Compacting the db didn't work. Any thoughts?

[Kurt]

Re: Append to master replication table

Problem solved. A foreign key field in the master table had a default
value which did not ref. a valid item in the link table.
Kurt wrote:[color=blue]
> For some reason I cannot use an append query to append records to a
> design master replication table that has the index key on a random Long
> Integer. I checked all the text fields in the Master Replication table
> to make sure the properties are appropriately set as
> Required: No and Allow Zero Length: Yes. Also no violation of unique
> indexes.
>
> The Access error message says can't append all the records,
> ...didn't add 1576 records to the table due to key violations...
>
> INSERT INTO tblMasterRepl ( tblspecies_ID, tblCounty_ID, StatusCo )
> SELECT FWS.SpeciesID, FWS.CountyID, FWS.STATUS
> FROM FWS
> WHERE (((FWS.Match)=F alse));
>
> Compacting the db didn't work. Any thoughts?[/color]