Annoyance: : "This Recordset is not updateable" from Pass through query

[Err]

Hi,

I wrote a dynamic pass through query and I'm getting the annoying pop up saying that

"This Recordset is not updateable"

I don't want my recordset to be updateable. This is intended. Can it not bother me?

Is there something I can do to turn this messaging off?

 

[Joe4]

Can you post the code of your query?

 

[Err]

Thanks,

I actually tried a different approach with dynamically writing my query and I didn't get that warning message any more. I was updating someone else's code and deleting and rewriting their parts seemed to fix the problem.

If I was to guess about which part that I wrote that fixed this issue... it would be this line

DoCmd.OpenQuery "Advanced_Data_Qry", acViewNormal, acReadOnly

Sorry, I can't be of more help. I've removed so much of the code that gave me that problem that I don't know what exactly caused it.