I am trying something new in my database in that I would like to call ALL or at least most of my queries from VBA.
I have managed to test that out with my first query successfully, however I get the error 3326 - this record is not updateable when I use the code. In the current state the user would need to End or Debug, which I would like to suppress if possible.
Is there a problem with calling SQL code from VBA that can't be updated? It seems to me just a normal result of some query strucutres.
Thank you to anyone who can offer advice or solutions.
Heather