Using SQL Commands in Access 2010

15. March 2011
Comments (0)


I tried using Access 2010 DB since I didn't have SQL Server set up on my latest PC. I prefer to use SQL queries in Access.


Problem: No SQL View present. Even when I added the SQL View to the toolbar it was not enabled.


Solution: Turns out there is a convoluted method of getting to the SQL View using the following steps:



1) Go to Create Tab on Toolbar and select Query Design.

GoToCreateTabandSelectQueryDesign



2) Access opens a Show Table dialog box. Press Close (don't need to select a table).

ShowTableDialog



3) Now can select SQL View (it's enabled under the View dropdown also).

SelectSQLView



4) Type in your SQL command and hit Run.

 


 

 

 

  By John Dorsey  IT Brigade Inc.        

Access ,