Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0R0uGq69214 for ; Fri, 26 Jan 2001 19:56:16 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from vmx.mediaparks.lv (vmx.mediaparks.lv [62.85.15.11]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0QIfiq33877 for ; Fri, 26 Jan 2001 13:41:44 -0500 (EST) (envelope-from emils@grafton.lv) Received: (from mail@localhost) by vmx.mediaparks.lv (8.9.3/8.9.3) id UAA98847 for pgsql-sql@postgresql.org; Fri, 26 Jan 2001 20:41:42 +0200 (EET) (envelope-from emils@grafton.lv) X-Authentication-Warning: vmx.mediaparks.lv: mail set sender to emils@grafton.lv using -f Received: from 159.148.192.252 by 62.85.15.11 id Ed74su7k ; 26 Jan 2001 20:41:31 EET Received: from mortyr (mortyr.grafton.lv [159.148.192.196]) by home.grafton.lv (8.9.3/8.8.7) with ESMTP id UAA16557 for ; Fri, 26 Jan 2001 20:41:02 -0200 From: "Emils Klotins" Organization: Grafton Entertainment To: pgsql-sql@postgresql.org Date: Fri, 26 Jan 2001 20:42:44 +0200 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: Re: #DELETED error when using Access 2000 as frontend Message-ID: <3A71E144.26096.EC47B9E@localhost> In-reply-to: <3A6FA3AF.FE182608@pakrat.com> X-mailer: Pegasus Mail for Win32 (v3.12c) X-Archive-Number: 200101/403 X-Sequence-Number: 1076 > > I want to use pg 7.x as a backend for a MS Access application. I linked a > > table via ODBC, using the newest ODBC driver. I can open and view tables. But > > after I insert a new record, all fields will contain "#deleted". When I > > reopen the table, the inserted data is displayed correctly. > I recall seeing an MS Access 2000 bug that will cause this. I don't remember I can confirm the problem exists at least in access'97 -- applying both of the office'97 service packs helped. I have noticed all kinds of weird errors in Access which makes it operate badly with Postgres and I really can't recommend it as a frontend application, although I know there are people who use it quite successfully. On a side note - pls reply privately - what Win frontends (apart from web) have people used with Postgres, which work OK for them? Emils ---------------------- Emils Klotins IT Manager, Baltic states Grafton Entertainment Ltd. / TVNET 40-43 Brivibas Str., Riga LV1050, Latvia +371-7-242-001