Hey guys, I have a make-table query, let's call it "MyQuery." I am having trouble getting the docmd.openquery method to work on this particular query. You can run the query manually and it seems to work fine, but when I try to run it in code it gets sent to my errorhandler. I tried turning the warnings back on and I get the messages:
"You are about to run a query...." and "The existing table will be deleted...".
After the second message is when the errorhandler picks up. The records never get added to the table.