Skip site navigation (1) Skip section navigation (2)

MS Access 97 SR-1, psqlodbc, slow perfomance

From: Jüri Fjodorov <jyri(dot)fjodorov(at)nowecanspam(dot)ee>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: MS Access 97 SR-1, psqlodbc, slow perfomance
Date: 2001-07-10 14:26:12
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
hi all!

im just trying to migrate my ms access back-end to postgres. i used
pgadmin for it and now i have tables stored in postgres on mandrake 7.2
server. frontend is still ms access.(at least im trying redoing it for

problem is, when i do something(anything) with bounded
form/report(changing text box source, for example), access makes
connection to backend. i dont realy know what it do there as i am a
newbie at postgres, but its real pain in the butt with about 1000K
records in few tables. you see, i dont like to wait 2 mins just for
changing text box source.

i have strange feeling that its not normal and something configured
wrong. why access have to access backend all the time while i am in
form/report edit mode?

anyone can help me out?
thanx in advance

pgsql-interfaces by date

Next:From: Steve WamplerDate: 2001-07-10 16:58:40
Subject: Re: [JDBC] Re: Too much data received?
Previous:From: Barry LindDate: 2001-07-10 01:21:54
Subject: Re: Too much data received?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group