Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: linked tables in MS Access
- From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
- To: Jiří Nouza <nouza(at)seznam(dot)cz>
- Cc: pgsql-odbc(at)postgresql(dot)org
- Subject: Re: linked tables in MS Access
- Date: Tue, 23 Jan 2007 18:25:04 +0900
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
- References:
- linked tables in MS Access
- From: Jiří Nouza
- linked tables in MS Access
- Prev by Date: linked tables in MS Access
- Next by Date: Re: linked tables in MS Access
- Previous by thread: linked tables in MS Access
- Next by thread: Re: linked tables in MS Access
- Indexes: