Access as a front-end or another query builder

From: Ellen Cyran <ellen(at)urban(dot)csuohio(dot)edu>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Access as a front-end or another query builder
Date: 2006-02-23 16:17:49
Message-ID: 43FDE02D.4010907@urban.csuohio.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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?

Ellen

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Dianne Yumul 2006-02-23 17:07:25 Re: Is psqlodbc what I'm looking for
Previous Message Michael Shulman 2006-02-23 13:50:23 Re: psqlODBC generating incorrect SQL?