Operation must use an updatable query. (Error 3073)

I am working with MS-Access 2002. The two tables that I am working with
are:

dbo_IDX_FRS_account_bal_by_month ==> this is a linked table to SQL
[Select FY_06 to-date] == local table

The query that is executed is
=============================

UPDATE dbo_IDX_FRS_account_bal_by_month INNER JOIN [Select FY_06
to-date] ON (dbo_IDX_FRS_account_bal_by_month.account = [Select FY_06
to-date].account) AND (dbo_IDX_FRS_account_bal_by_month.acct_control =
[Select FY_06 to-date].acct_control) SET
dbo_IDX_FRS_account_bal_by_month.FY_06 = [FY_05]+[SumOfAMOUNT],
dbo_IDX_FRS_account_bal_by_month.FY_06_MAY = [FY_05]+[SumOfAMOUNT];

When this query is executed, I get following error "Operation must use
an updatable query. (Error 3073)" I have tried many things like putting
distinctrow on the update query but nothing seems to be working. I also
read something about if the database was converted from access 97.

Thanks in advance,
Julio

re: Operation must use an updatable query. (Error 3073)

Does the local table, [Select FY_06 to-date], have a primary key? If
not, then try adding one. That usually would get rid of the problem.

re: Operation must use an updatable query. (Error 3073)

Did JV's suggestion to set up a primary key on the local table
fix your problem?

re: Operation must use an updatable query. (Error 3073)

I know this may sound silly, but it has bit me
square in the ass a couple of times. I have
had runtime mde files installed on the target
machine with +R file attributes. I have no
freaking idea why this happens, but it has.

So, just check that.