Forum Discussion
Query failure in Windows 11
Hi
I just had a new computer at work, and changed from windows 10 to windows 11.
I have a query, which compare 2 tables, and add rows in table2 that dont exits in table1.
This has been working for years, but now it, only sometimes, double all the rows.
INSERT INTO MPS Columns from Table2 (Access linked to sharepoint)
SELECT MPS2. Columns from table1
FROM MPS2
WHERE not exists (Select 1 from MPS WHERE MPS.[MPSid] = MPS2.[MPSid]);
It compares a unik field MPSid
It doubles the rows sometimes, and the MPSid is the same, in the doubled rows
Has something changed, or is there a workaround?
Best Regards
Tony
1 Reply
- ViorelCopper Contributor
Do you mean that the MPSid column has duplicate values too? Isn't it restricted to disallow duplicates (like a primary key, for example)?