Skip site navigation (1) Skip section navigation (2)

Re: Access as a front-end or another query builder

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: "Relyea, Mike" <Mike(dot)Relyea(at)xerox(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org, Ellen Cyran <ellen(at)urban(dot)csuohio(dot)edu>
Subject: Re: Access as a front-end or another query builder
Date: 2006-02-24 10:37:07
Message-ID: 43FEE1D3.4010604@pse-consulting.de (view raw or flat)
Thread:
Lists: pgsql-odbc
Relyea, Mike wrote:
> Ellen,
> 
> I use Access as my front end, and had the same problem.  In the end I
> ended up using pass-thru queries that I created on the fly with a little
> VBA.  I still use the query builder in Access to get all of my joins
> right (it's so much easier to see it visually when there are a lot of
> joins).  I bring the SQL that Access generates into Notepad and hand
> massage it until I've got it just right. 

For this hand massaging job I'd recommend pgAdmin's query tool: you have 
syntax highlighting and can check syntax and performance immediately.

We still don't have a programmer who's interested in spending time on a 
query builder for pgAdmin, volunteers are welcome.

Regards,
Andreas

In response to

pgsql-odbc by date

Next:From: Dianne YumulDate: 2006-02-24 17:34:52
Subject: Compile error on Mac OS X
Previous:From: Goulet, DickDate: 2006-02-23 23:56:57
Subject: Re: Access as a front-end or another query builder

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group