Newbie odbc simple select maybe cache problem

Hello
I have connected table from ms access2000 to postgres table on server. I
execute query which selects all records in normal view. When i try scroll
result have allways delay before displaying next 10 recors. In some cases
its ok, but in my, better will be caching 100 records not only 10. Where can
i set it ? I've tried some options in odbc driver, but none has changed.
Please help.

Cody
ps. i have also tried selecting in ro mode and result was the same...


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html