Updateable query failing in Runtime - 2010

[ChefContainer]

Hello all.



I have a FE/BE application which functions correctly on regular Access 2010.

I have compiled this creation but when I try to run on a runtime machine some of the functions receive the error Operation must use an updateable query. The actual queries that are failing are append query yet not all the append queries in the project fail.

Any suggestions?

Thanks!

sjipping@chefcontainer(dot)com

[NTC]

I can't explain why it is only appearing in runtime. and that is going to be frustrating to have to go back and forth in order to trial/test.......

But in general; a component of the query (s) that feed into the append query are triggering this. Modify your appendquery to be a MakeTable query and make a new table - its ok if it is a local table as it is essentially a scratch pad. then make a new append query that uses this new table as the record source. that will probably work.

you will have to trigger the Make always before the Append of course..... set warning off so that the Make doesn't trigger a prompt because the table already exists...

hope it helps....