Received: from yara.imsd.uni-mainz.de (yara.IMSD.Uni-Mainz.DE [134.93.144.68])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0MCK8024262
	for <pgsql-interfaces@postgresql.org>;
	Mon, 22 Jan 2001 07:20:08 -0500 (EST)
	(envelope-from wagner@imsd.uni-mainz.de)
Received: (from smap@localhost)
	by yara.imsd.uni-mainz.de (8.9.3/8.9.3/lxs_5.2) id NAA21996
	for <pgsql-interfaces@postgresql.org>; Mon, 22 Jan 2001 13:19:04 +0100
Received: from hermes.imsd.uni-mainz.de(134.93.64.80) by
	yara.imsd.uni-mainz.de via smap (V2.1/2.1+anti-relay+anti-spam)
	id xma021990; Mon, 22 Jan 01 13:18:45 +0100
Received: from imsd.uni-mainz.de (unverified [134.93.64.34]) by
	hermes.imsd.uni-mainz.de
	(EMWAC SMTPRS 0.83) with SMTP id <B0000223983@hermes.imsd.uni-mainz.de>;
	Mon, 22 Jan 2001 14:19:28 +0100
Message-ID: <3A6C26E2.EF766990@imsd.uni-mainz.de>
Date: Mon, 22 Jan 2001 13:26:10 +0100
From: Markus Wagner <wagner@imsd.uni-mainz.de>
Organization: IMSD
X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.13 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: "pgsql-interfaces@postgresql.org" <pgsql-interfaces@postgresql.org>
Subject: pg 7.x and Access 2000 -> #deleted error
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200101/231
X-Sequence-Number: 849

Hi,

I am using pg 7.x as a db server and MS Access should be the frontend
for windows clients. I installed the newest ODBC driver on the windows
machine. I can link in and open tables from the pg server. But when I
make changes/inserts, all fields of the current record will contain
"#deleted". I have to close and reopen the table to see the newly
entered/changed data.

Any hints to get this working?

Thanks,

Markus