Received: from mail01.phoenixdsl.com (mail.phoenixdsl.com [216.178.151.24]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0MHpJ053256 for ; Mon, 22 Jan 2001 12:51:19 -0500 (EST) (envelope-from mdavis@sevainc.com) Received: (qmail 21179 invoked by uid 89); 22 Jan 2001 17:51:18 -0000 Received: from unknown (HELO SALLY) (64.32.157.45) by 0 with SMTP; 22 Jan 2001 17:51:18 -0000 Received: by localhost with Microsoft MAPI; Mon, 22 Jan 2001 10:51:17 -0700 Message-ID: <01C08461.3F8D4190.mdavis@sevainc.com> From: Michael Davis Reply-To: "mdavis@sevainc.com" To: "'Markus Wagner'" , "pgsql-interfaces@postgresql.org" Subject: RE: pg 7.x and Access 2000 -> #deleted error Date: Mon, 22 Jan 2001 10:51:11 -0700 Organization: Seva Inc. X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/246 X-Sequence-Number: 864 Is there a primary key installed on the table? Is "Recognize Unique Indexed" enabled in the ODBC drivers data source? Make sure both of these are true solved a similar problem for me with Access 97. -----Original Message----- From: Markus Wagner [SMTP:wagner@imsd.uni-mainz.de] Sent: Monday, January 22, 2001 5:26 AM To: pgsql-interfaces@postgresql.org Subject: pg 7.x and Access 2000 -> #deleted error 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