Received: from mail.greatbridge.com ([216.54.52.25])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0MEU7032912
	for <pgsql-interfaces@postgresql.org>;
	Mon, 22 Jan 2001 09:30:07 -0500 (EST)
	(envelope-from ned@greatbridge.com)
Received: from greatbridge.com (j79.us.greatbridge.com [216.54.52.219])
	by mail.greatbridge.com (8.9.3/8.8.7) with ESMTP id JAA09255;
	Mon, 22 Jan 2001 09:26:42 -0500
Message-ID: <3A6C52CC.20105@greatbridge.com>
Date: Mon, 22 Jan 2001 09:33:32 -0600
From: Ned Lilly <ned@greatbridge.com>
User-Agent: Mozilla/5.0 (X11; U; Linux 2.2.16-22 i686; en-US;
	0.7) Gecko/20010105
X-Accept-Language: en
MIME-Version: 1.0
To: Markus Wagner <wagner@imsd.uni-mainz.de>
CC: "pgsql-interfaces@postgresql.org" <pgsql-interfaces@postgresql.org>
Subject: Re: pg 7.x and Access 2000 -> #deleted error
References: <3A6C26E2.EF766990@imsd.uni-mainz.de>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200101/237
X-Sequence-Number: 855

Hi Markus,

I think this is an Access issue - I seem to recall having the same 
problem with an Access front-end to Oracle a year or so ago.

Regards,
Ned


Markus Wagner wrote:

> 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
> 
> 

-- 
----------------------------------------------------
Ned Lilly                     e: ned@greatbridge.com
Vice President                w: www.greatbridge.com
Evangelism / Hacker Relations        v: 757.233.5523
Great Bridge, LLC                    f: 757.233.5555