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;
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;