Turn off "Microsoft Access can't append all the records in the append query"
Hi All
I have an Append Query to add records from "TblCustomerImport" to "TblCustomers" the problem that I have is duplication of the existing records in"TblCustomers" I have tried the SQL below:
INSERT INTO TblCustomers ( JobNo, CustName, Address, Date )
SELECT DISTINCT TblCustomerImport.F1, TblCustomerImport.F2, TblCustomerImport.F3, TblCustomerImport.F4
FROM Customer_Import
WHERE NOT Exists (SELECT 1 FROM Customers_Without_Duplicates WHERE Customers_Without_Duplicates.JobNo = TblCustomerImport.JobNo;
This works but I get "Microsoft Access can't append all the records in the append query".
Is there any way of answering yes to this, over ride it or not have it display.
DAvRob
Hi All
I have an Append Query to add records from "TblCustomerImport" to "TblCustomers" the problem that I have is duplication of the existing records in"TblCustomers" I have tried the SQL below:
INSERT INTO TblCustomers ( JobNo, CustName, Address, Date )
SELECT DISTINCT TblCustomerImport.F1, TblCustomerImport.F2, TblCustomerImport.F3, TblCustomerImport.F4
FROM Customer_Import
WHERE NOT Exists (SELECT 1 FROM Customers_Without_Duplicates WHERE Customers_Without_Duplicates.JobNo = TblCustomerImport.JobNo;
This works but I get "Microsoft Access can't append all the records in the append query".
Is there any way of answering yes to this, over ride it or not have it display.
DAvRob