Results 1 to 2 of 2
  1. #1
    Dinzdale40 is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2010
    Posts
    12

    Saving in Design View Changes INTO statement in Make Table Query

    I have several make table queries that create an excel file. Each of my queries makes a different sheet in the file. Whenever I go to change something as I work on it and go into design view and save, it will mess up my sql. I always check it right before and after I save and it is there, but if I close it after saving and reopen the query I can see that it deleted the alternate database name in my INTO statement.

    Basically it drops the alternate database and just tries to make the table into the excel sheet's name(which goes no where or creates a table in the current datase).

    Is there something I can do to keep this from happening everytime I edit in design view? I'm a visual person and sometimes my head hurts looking at SQL and I have to go back to design view to problem solve.



    Thanks,

  2. #2
    Dinzdale40 is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2010
    Posts
    12
    bump...any thoughts?

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

Similar Threads

  1. Using a Design View Query in ADO?
    By danny2000 in forum Access
    Replies: 4
    Last Post: 12-06-2010, 03:36 AM
  2. Replies: 8
    Last Post: 12-04-2010, 07:53 PM
  3. Replies: 9
    Last Post: 09-25-2010, 10:14 AM
  4. Query Design View Takes a Long Time to Open
    By jackthedog in forum Queries
    Replies: 0
    Last Post: 12-22-2009, 03:27 PM
  5. Replies: 2
    Last Post: 10-27-2009, 07:09 AM

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