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

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

From: "Goulet, Dick" <DGoulet(at)vicr(dot)com>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>,"Ellen Cyran" <ellen(at)urban(dot)csuohio(dot)edu>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Access as a front-end or another query builder
Date: 2006-02-23 23:56:57
Message-ID: 4001DEAF7DF9BD498B58B45051FBEA65032FC397@25exch1.vicorpower.vicr.com (view raw or flat)
Thread:
Lists: pgsql-odbc
You might try WinSql from
http://www.synametrics.com/SynametricsWebApp/WinSQL.jsp  They have a
query wizard that works with Postgresql.  Not sure if the free version
has it or not, but at $250 per copy it's not what I'd call expensive. 

-----Original Message-----
From: pgsql-odbc-owner(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Jim C. Nasby
Sent: Thursday, February 23, 2006 6:54 PM
To: Ellen Cyran
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] Access as a front-end or another query builder

On Thu, Feb 23, 2006 at 11:17:49AM -0500, Ellen Cyran wrote:
> I've tried the many suggestions about making Access as a front-end to 
> postgreSQL faster, i.e. turned the ODBC trace off, set Declare/Fetch
On, 
> used the commlog, but it still is about 10 times slower than running
the 
> queries in pgadmin.  The Access pass-thru queries kind of defeat the 
> purpose of having a query builder since there isn't any design view
with 
> them. Is there an FAQ on setting up Access as a front-end or just
steps 
> that are known to provide reasonable performance?
> 
> Are there any good free query builders out there?

Unfortunately I don't know of any good GUI front ends, free or not. But
if you're only looking to build queries that you're then embedding into
an application, there are probably some commercial tools you could use
But since I do stuff 'the hard way', I can't really recommend any.
Though, would pgAdmin do what you wanted? It might have a query builder.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby(at)pervasive(dot)com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
       message can get through to the mailing list cleanly

pgsql-odbc by date

Next:From: Andreas PflugDate: 2006-02-24 10:37:07
Subject: Re: Access as a front-end or another query builder
Previous:From: Jim C. NasbyDate: 2006-02-23 23:53:31
Subject: Re: Access as a front-end or another query builder

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