Results 1 to 2 of 2
  1. #1
    Dave_D's Avatar
    Dave_D is offline Advanced Beginner
    Windows XP Access 2010 64bit
    Join Date
    Aug 2015
    Posts
    67

    UNION query is creating a "Name AutoCorrect Save Failure" table


    I've created a UNION query when run by itself opens the result set just fine. However, when executing the query with a DoCmd.OpenQuery statement, the result set opens (wondering why it opens; just because it's a SELECT) and new table is automatically created with a name of "Name AutoCorrect Save Failure"; where the result set is not saved. I was originally trying to do a UNION query with an INSERT INTO, but upon reading that it's best to do in 2 steps. I need the results set saved so that it can be Appended/Inserted into a new table.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Q1 the union table
    Q2 the append of Q1

    (tho I have never seen that error table before ?!?)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 02-08-2016, 09:52 AM
  2. Replies: 3
    Last Post: 12-06-2014, 03:59 AM
  3. Replies: 5
    Last Post: 02-05-2013, 10:57 PM
  4. Linked Table Manager - No "Save PW"
    By dweller569 in forum Import/Export Data
    Replies: 1
    Last Post: 07-30-2011, 07:27 AM
  5. Replies: 11
    Last Post: 11-26-2010, 10:53 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums