"Operation Must Be An Updateable Query" Error

[ChiTownDiva]

For whatever reason, I've started getting the infamous <i>&quot;Operation Must Be an Updateable Query&quot;</i> error message for every append or update query I try to run in Access 2000.

I'm talkin' queries that worked yesterday and for some stupid reason, don't work today!!!

Here's an example (SQL view):

<B>UPDATE Test1 AS Test1_1 INNER JOIN [tblNortel_Orders_Daily] ON [Test1_1].[Order_No] = [tblNortel_Orders_Daily].[Order_No] SET [tblNortel_Orders_Daily].INVOICED = [Test1_1].Action, [tblNortel_Orders_Daily].DateFunded = [Test1_1].datefunded;</b>

I get the same dumb error message when I run an &quot;Append&quot; query as well.

Does anybody have a clue why this is happening? This query ran fine for 4 months. No one's changed any of table or field properties/definitions.

 

[Quehay]

Here's a guess (it's hard to figure out which tbl is One and which Many--if that's the structure): You're trying to update on the &quot;One&quot; side of a join. If you set the Query to &quot;Dynaset Inconsistent Updates&quot; it will let you update on &quot;One&quot; fields.

(The wiseguy answer would be &quot;It's because you've HTML tags in your SQL code,&quot; but I've done the same thing a bunch of times here.)

 

[ChiTownDiva]

The HTML tags were a feeble attempt to highlight.

Here's the SQL view:

UPDATE Test1_1 AS Test1_1 INNER JOIN [tblNortel_Orders_Daily] ON [Test1_1].[Order_No] = [tblNortel_Orders_Daily].[Order_No] SET [tblNortel_Orders_Daily].DateFunded = [Test1_1].datefunded;