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

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

From: "Relyea, Mike" <Mike(dot)Relyea(at)xerox(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Cc: "Ellen Cyran" <ellen(at)urban(dot)csuohio(dot)edu>
Subject: Re: Access as a front-end or another query builder
Date: 2006-02-23 20:19:25
Message-ID: 1806D1F73FCB7F439F2C842EE0627B18037D30B8@usa0300ms01.na.xerox.net (view raw or flat)
Thread:
Lists: pgsql-odbc
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.  After I've got the SQL the way
I want it, I use that string of SQL in VBA and generate my queries on
the fly, changing each of the criteria that needs to be changed each
time I generate the query.  Check out:
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=82&Number=5141
04&Forum=,,All_Forums,,&Words=&Searchpage=1&Limit=25&Main=510514&Search=
true&where=&Name=57586&daterange=&newerval=&newertype=&olderval=&olderty
pe=#Post514104&bodyprev=

Mike

-----Original Message-----
From: pgsql-odbc-owner(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Ellen Cyran
Sent: Thursday, February 23, 2006 11:18 AM
To: pgsql-odbc(at)postgresql(dot)org
Subject: [ODBC] Access as a front-end or another query builder

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


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Responses

pgsql-odbc by date

Next:From: Jim C. NasbyDate: 2006-02-23 23:53:31
Subject: Re: Access as a front-end or another query builder
Previous:From: Dianne YumulDate: 2006-02-23 19:34:51
Subject: Re: Is psqlodbc what I'm looking for

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