Thread: Re: Viewing linked large postgres tables with Access: Running out of memory
Re: Viewing linked large postgres tables with Access: Running out of memory
From
esimbo@openlinksw.co.uk (Emmon Simbo)
Date:
Hi I had a customer with a similar problem to you. I believe the solution to your problem is to set the UseDeclareFetch to Yes. I believe this stops it from doing the query on the Client. Emmon Simbo OpenLink Software iant@the-wire.com (moonman) wrote in message news:<522ac696.0310281113.75fac6a6@posting.google.com>... > Hello all, > > First, let me explain hat I'm an absolute database novice. The reason > I've made so much progress sofar with postgresql is that it is an > amazing software suite with exceptional documentation. So if I'm > asking an idiotic question, I apologize... but atleast tell me what > the obvious is. > > I just downloaded the psqlodbc_07_03_0200.zip windows odbc drivers for > postgresql. > > I can link to my postgresql server and generally do queries no > problem. > > My problem is that my users have the annoying habit of clicking on the > linked table icon to view some of the data. > > When they do this, the memory used by MS Access grows until there is > no memory left. > > Short of ridiculing the users into proper behaviour, is there some way > to configure the ODBC driver to only show 'x'-number of records at a > time (similar to the Oracle ODBC driver we currently have on other > databases)? > > Thanks in advance > > moonman