Re: Viewing linked large postgres tables with Access: Running out of memory

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(at)the-wire(dot)com (moonman) wrote in message news:<522ac696(dot)0310281113(dot)75fac6a6(at)posting(dot)google(dot)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