pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Colin Faber <cfaber@fpsn.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: #DELETED error when using Access 2000 as frontend
Date: Fri, 26 Jan 2001 18:24:58 -0700
Message-ID: <3A72236A.D4507F2C@fpsn.net> (raw)
References: <3A71E144.26096.EC47B9E@localhost>

these are common errors on the mysql side also. Most likely poor planing on the
Access end.


Emils Klotins wrote:

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




view thread (4+ messages)

Message-ID: <3A72236A.D4507F2C@fpsn.net>
Permalink:  ../3A72236A.D4507F2C@fpsn.net/
Also on:    postgresql.org/message-id/3A72236A.D4507F2C@fpsn.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: cfaber@fpsn.net
  Subject: Re: #DELETED error when using Access 2000 as frontend
  In-Reply-To: <3A72236A.D4507F2C@fpsn.net>
  References: <3A71E144.26096.EC47B9E@localhost> <3A72236A.D4507F2C@fpsn.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox