By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,705 Members | 1,195 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,705 IT Pros & Developers. It's quick & easy.

Operation must use an updatable query. (Error 3073)

P: n/a
I am working with MS-Access 2002. The two tables that I am working with

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,

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies

P: n/a
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.

Nov 13 '05 #2

P: n/a
Did JV's suggestion to set up a primary key on the local table
fix your problem?
Nov 13 '05 #3

P: n/a
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.
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.