View Single Post
  #6 (permalink)  
Old November 29th, 2008, 05:09 PM
chobo2 chobo2 is offline
Friend of Wrox
 
Join Date: Sep 2007
Location: , , .
Posts: 169
Thanks: 7
Thanked 2 Times in 2 Posts
Default

Hi

where is tool->options->Table/Queries on the ribbon?

With this "I usually would type that into the design builder and then execute it"

What I mean is when you go through a typed dataset wizard it has a sql query builder where you can just click some options and it would generate the sql for you. It also has an execute button that allows you try the statements out so you can see if it's what you want to return.


I was using that to try my sql queries out since I did not know access had it's own tester.