Update Query (Updating a linked SQL table)

[Blorf]

Hello.

I have an item list table in SQL, linked to an Access D/B. The description needs to be updated when changes are made to our Enterprise software, so I create a table local to the access db, and run the following to check for description changes and do the update. For some reason, the query times out. I am hoping it's just a mistake I can't see.

IM1 is the linked SQL table, IM1_Temp is the local table.

Thanks,
Chaz

UPDATE IM1 INNER JOIN IM1_Temp ON IM1.ItemNumber = IM1_Temp.ItemNumber SET IM1.ItemDescription = [im1_temp].[ItemDescription]
WHERE ((([IM1].[ItemDescription]=[IM1_Temp].[ItemDescription])=False));




There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[JonFer]

Make sure ItemNumber has a unique index in both tables.

 

[Blorf]

The SQL ItemNumber is primary Key. I will alter the other side in the morning and let you know.

I appreciate your suggestion.

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.