By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,795 Members | 1,666 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,795 IT Pros & Developers. It's quick & easy.

Append to master replication table

P: n/a
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)=False));

Compacting the db didn't work. Any thoughts?

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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:
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)=False));

Compacting the db didn't work. Any thoughts?


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.