>Hi all..i've downloaded the pgsql odbc 0004 driver from the ftp site and i'm using it to access a pgsql database that i have >exported from access 97...one of my tables has about 300000 records and when i try to open it from access 2000 as a linked >table, ms accessgiving me an error concerning low memory... >The question i have is: am i using the correct odbc driver or should i download something else..(i noticed there is another driver >>0005 in the "full" directory...)
Maybe you should switch on cursor control (Use Declare/Fetch) in the driver. Otherwise the system will try to cache the whole table. And of course it is better to use the latest driver (0005).