Forum Discussion

thansson's avatar
thansson
Copper Contributor
Oct 23, 2025

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

  • Viorel's avatar
    Viorel
    Copper 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)?

Resources