Syntax Error

This brings up a syntax error:



UPDATE ItemT.D3Qty

SET ItemT.D3Qty - TransactionT.Quantity

WHERE TransactionT.Item = ItemT.Item AND (TransactionT.TransactionType = "Adjustment" OR TransactionT.TransactionType = "Usage");



And when I change it to this:



UPDATE ItemT.D3Qty

SET ItemT.D3Qty = ItemT.D3Qty - TransactionT.Quantity

WHERE TransactionT.Item = ItemT.Item AND (TransactionT.TransactionType = "Adjustment" OR TransactionT.TransactionType = "Usage");



I get the following error:



Could not find file '..........\Documents\ItemT.mdb'.



Am I completely writing this incorrectly? Is there a better way? How can I make this work?

Syntax Error