By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,834 Members | 2,240 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,834 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

ia**@the-wire.com (moonman) wrote in message news:<52**************************@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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.