Running Linked table through an update query

W

Will G

somehow, the data between linked access table is not going to my existing
table when i run the update query.
the query doesnt give me any error, but it say that i am about to update 0
rows and the information doesnt go to the existing table. here is my query:

UPDATE SalesOrder1 INNER JOIN LinkedSalesOrder ON SalesOrder1.OrderNo =
LinkedSalesOrder.OrderNo SET SalesOrder1.OrderNo =
[LinkedSalesOrder].[OrderNo], SalesOrder1.ID = [LinkedSalesOrder].[ID],
SalesOrder1.RequiredDate = [LinkedSalesOrder].[RequiredDate],
SalesOrder1.ID_1 = [LinkedSalesOrder].[ID_1], SalesOrder1.Description =
[LinkedSalesOrder].[Description], SalesOrder1.Comment1 =
[LinkedSalesOrder].[Comment1], SalesOrder1.Comment2 =
[LinkedSalesOrder].[Comment2], SalesOrder1.OrderQty =
[LinkedSalesOrder].[OrderQty]
WITH OWNERACCESS OPTION;

does anyone have an idea why?
 
Top