Problem Appending

  • Thread starter Thread starter Rover
  • Start date Start date
R

Rover

I have to identical tables that had key fields which I have removed so
neither table has keys. When I try to append CustomersSW into Customers
using the query below I get the "Access can't append ... 185 records
(the entire table) due to KEY violations. THERE ARE NO KEYS!! What am
I doing wrong?

tia
Jim

P.S. Before I removed the keys, I could see NO key conflicts anyway.

INSERT INTO Customers
SELECT CustomersSW.*
FROM CustomersSW;

This doesn't work either:

INSERT INTO Customers ( CustomerID, Prefix, RouteID, CompanyName, Title,
ContactFirstName, ContactLastName, HouseNumber, StreetName, Direction,
City, StateorProvince, PostalCode, County, BillingAddress, PhoneNumber,
WorkPhone, FaxNumber, Notes, SquareFtFS, SquareFtWY, PriceFS, PriceWY,
LimingPrice, AerationPrice, PrePayPrice, [T/E], App1, App2, App3, App4,
Merit, WinterFeed, SoilStrl, Nutsedge, Liming, Aeration, PrePay,
Call1st, Call1stP, SpecialInstructions, [D/C], Active, Owner )
SELECT CustomersSW.CustomerID, CustomersSW.Prefix, CustomersSW.RouteID,
CustomersSW.CompanyName, CustomersSW.Title,
CustomersSW.ContactFirstName, CustomersSW.ContactLastName,
CustomersSW.HouseNumber, CustomersSW.StreetName, CustomersSW.Direction,
CustomersSW.City, CustomersSW.StateorProvince, CustomersSW.PostalCode,
CustomersSW.County, CustomersSW.BillingAddress, CustomersSW.PhoneNumber,
CustomersSW.WorkPhone, CustomersSW.FaxNumber, CustomersSW.Notes,
CustomersSW.SquareFtFS, CustomersSW.SquareFtWY, CustomersSW.PriceFS,
CustomersSW.PriceWY, CustomersSW.LimingPrice, CustomersSW.AerationPrice,
CustomersSW.PrePayPrice, CustomersSW.[T/E], CustomersSW.App1,
CustomersSW.App2, CustomersSW.App3, CustomersSW.App4, CustomersSW.Merit,
CustomersSW.WinterFeed, CustomersSW.SoilStrl, CustomersSW.Nutsedge,
CustomersSW.Liming, CustomersSW.Aeration, CustomersSW.PrePay,
CustomersSW.Call1st, CustomersSW.Call1stP,
CustomersSW.SpecialInstructions, CustomersSW.[D/C], CustomersSW.Active,
CustomersSW.Owner
FROM CustomersSW;
 
open the destination (receiving) table in design view and click the Indexes
button on the toolbar. look at each index listed to see if there are any set
as Unique = Yes.

btw, instead of removing the primary key fields from the tables, suggest you
try simply *not* appending that field in the query.

hth
 
Back
Top