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@xxxxxxxxxxxx (moonman) wrote in message 
news:<522ac696.0310281113.75fac6a6@xxxxxxxxxxxxxxxxxx>...
> 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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings