#1
  1. Salaryman
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2002
    Location
    St. Louis, MO
    Posts
    341
    Rep Power
    71

    Question MS Access 2002: is it possible to set the default design view?


    Firstly, sorry if this is not the correct forum for this question; it looked like it would be the closest though.

    I am using Microsoft Access 2002, and I would really like to be able to have my default query design view be SQL. Right now it always defaults to a Query Wizard, so I gotta get that going, then right click to choose SQL view. Anyone know if its possible to make it start directly in SQL mode? Any help would be really appreciated, thanks alot.
  2. #2
  3. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2002
    Location
    a northern town
    Posts
    74
    Rep Power
    13
    Hi,

    Once you create a new query, if you save it whilst in SQL view, it then opens it in SQL view by default next time.

    Ed.
    /* measure twice, cut once */

IMN logo majestic logo threadwatch logo seochat tools logo