Update to a different database in a different directory

[Arvin Villodres]

Good day to everyone!

I need to update a table from a different database in a
different directory
having "totals" as its tablename and ItemIDGroup,
ItemDescGroup, TotDel for
its field names. The table in the current direcetory that
would update
"totals" is "Trivia" with ItemID, ItemDesc, and
SumOfQtyDelivered for its
fieldnames.

I made this SQL statement:

UPDATE totals
IN 'N:\MMS CENTRAL\IC\ictot.mdb'
INNER JOIN Trivia
ON totals.ItemIDGroup = Trivia.ItemID
SET totals.ItemIDGroup = [ItemID], totals.ItemDescGroup =
[ItemDesc], totals.TotDel = [SumOfQtyDelivered];

But if I try to run it a message "Syntax Error on Update
Statement" would appear.
What did I do wrong?

Thanks.