Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f6GGwha13364 for ; Mon, 16 Jul 2001 12:58:43 -0400 (EDT) (envelope-from pgsql-interfaces-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6B4EHa96252 for ; Wed, 11 Jul 2001 00:14:17 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f6B477Q05576 for pgsql-interfaces@postgresql.org; Wed, 11 Jul 2001 00:07:07 -0400 (EDT) (envelope-from news) From: =?iso-8859-1?Q?J=FCri?= Fjodorov X-Newsgroups: comp.databases.postgresql.interfaces Subject: MS Access 97 SR-1, psqlodbc 7.01.00.06, slow perfomance Date: Tue, 10 Jul 2001 17:26:12 +0300 Organization: Wecan Cables Eesti =?iso-8859-1?Q?O=DC?= Lines: 22 Message-ID: <3B4B1084.4C0C0E1B@nowecanspam.ee> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@kadri.ut.ee X-Mailer: Mozilla 4.7 [en]C-CCK-MCD NexData (Win98; I) X-Accept-Language: en To: pgsql-interfaces@postgresql.org X-Archive-Number: 200107/57 X-Sequence-Number: 1810 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 postgres..) 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 jyri