Jiří Nouza wrote:
> Hello,
> I've read a post [1] about how MS Access is enjoyable and efficient when tables are connected to MS SQL.
>
> But I have MS Access front end containing linked tables to Postgres via ODBC. And I'm struggling with slow performance. When I want to open a table which contains about 8000 records it takes more then 20 sec. When I want to move cursor at the last record it takes more than 60 extra seconds.
> I'm not able to bind comboboxes directly to larger (more than 60 records) linked table because unrolling takes 20 sec
Aren't you turning on ODBC trace ?
regards,
Hiroshi Inoue