Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2002
    Posts
    4

    Question Unanswered: OpenQuery Command Not Working

    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.

    Any suggestions or ideas? Thanks.

    jimlast

  2. #2
    Join Date
    Feb 2002
    Posts
    403
    Delete the table first.

  3. #3
    Join Date
    Mar 2002
    Posts
    4
    Originally posted by dynamictiger
    Delete the table first.
    Tried that already, doesn't help.

    jimlast

  4. #4
    Join Date
    Mar 2002
    Posts
    4
    I found the problem. Turns out the make-table query was trying to write to a table that was already open. Just an oversight on my part. Thanks.

    jimlast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •