Operation must use an updateable query - in Access 2003

[Victor70]

Hello, everyone,

I have a legacy query that used to work in Access 2000 fine. After installation of Access 2003 (now I have both 2000 and 2003), I started getting this message - "Operation must use an updateable query".

I found a link to an article that explains this "improvement" - http://support.microsoft.com/kb/904953/en-us, but I still have Access 2000 and the query would not work there too.

Is there a fix to this?



Thanks a lot in advance
(asked also on http://www.access-programmers.co.uk/...22#post1142322)

[orange]

Can you show the sql of the query you are trying to execute?

This link may shed some light on the issue. http://allenbrowne.com/ser-61.html

[Victor70]

Orange, thank you very much for your response! Please see the SQL statement below.

Like I said before, the query was working fine (Access 2000) until newer Office versions were added. There were no changes made to the query. The Access 2000 is still installed. I wanted to keep it to allow for smooth migration to 2003. Now even if I open the database in Access 2000, I am getting this error.

INSERT INTO [XYZ Activities] ( Activity_ID, Empl_ID, Name, Bureau, Division, Unit, [Squad Or Shift], [Year], [Month], Activity, ID_Yr_Mo )
SELECT Str([fldc_id]) AS Activity_ID, Trim([emdept_id]) AS Empl_ID, Name, Bureau, Division, [Squad or Shift], Year([fcdate]) AS [Year], MonthName(Month([fcdate]),1) AS [Month], tmp_FIs.Activity, ID_Yr_Mo
FROM tmp_FIs INNER JOIN (dbo_emmain INNER JOIN dbo_systab1 ON dbo_emmain.emsection = dbo_systab1.code_agcy) ON tmp_FIs.officerid = dbo_emmain.empl_id
WHERE (((Trim([emdept_id]))<"3000") AND ((dbo_systab1.code_key)="SECT"));

[RuralGuy]

Each version of Access that is released corrects some issues or oversights with prior versions and introduces new issues that were not there before. Such is the life of a product. I noticed that your SQL contains some reserved words: http://www.allenbrowne.com/AppIssueBadWord.html
Each released version seems "pickier" that the prior version.

[Victor70]

Thanks, RuralGuy.

I do not think this has to do with the reserved words.

I changed the statement to the following and got the same error.

INSERT INTO [XYZActivities] ( Activity_ID, Empl_ID)SELECT Str([fldc_id]) AS Activity_ID, Trim([emdept_id]) AS Empl_ID
FROM tmp_FIs INNER JOIN (dbo_emmain INNER JOIN dbo_systab1 ON dbo_emmain.emsection = dbo_systab1.code_agcy) ON tmp_FIs.officerid = dbo_emmain.empl_id
WHERE (((Trim([emdept_id]))<"3000") AND ((dbo_systab1.code_key)="SECT"));