Re: #DELETED error when using Access 2000 as frontend

From: Ian Harding <iharding(at)pakrat(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: #DELETED error when using Access 2000 as frontend
Date: 2001-01-25 03:55:27
Message-ID: 3A6FA3AF.FE182608@pakrat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Markus Wagner wrote:

> Hi,
>
> I tried to subscribe to pgsql-interfaces several times and received "user not
> found". I also searched the pgsql-interfaces archives, without success. So
> here is my problem.
>
> 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.
>
> How can I fix this?
>
> Thank you,
>
> Markus

I recall seeing an MS Access 2000 bug that will cause this. I don't remember
the details, but I suspect a search of the knowledgebase at Microsoft (as soon
as their dns is fixed - they must be upgrading to windows 2000;^) will yield
the answer.

Ian

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Som 2001-01-25 04:50:27 Insertion and Retrieval of BLOB
Previous Message Brett W. McCoy 2001-01-25 02:59:36 Re: Re: Problem with Dates