[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