[Tfug] MSAccess frontend to PostgreSQL?

Glen Pfeiffer glen at thepfeiffers.net
Tue Jul 8 11:27:37 MST 2008


On Tue Jul 08, 2008 at 10:54:34AM -0700, Matt Jacob wrote:
> Glen Pfeiffer wrote:
> > 
> > For the most part, it speaks standard SQL.
> 
> Access does? The last time I had to use it was about 3 years ago 
> (thankfully), but I remember some kind of visual query builder where you 
> click and select columns you want and then drag to create relations. It 
> was actually quite the PITA for someone who knows SQL, as it would have 
> been faster for me to type out the queries by hand.

Yes, Access does.

1. In the query builder you can open the SQL view, and enter an 
   SQL statement.
2. You can execute queries against Access from any language with  
   an ODBC library, so obviously you are not restricted to using 
   the query builder.

-- 
Glen 





More information about the tfug mailing list