Re: Access 2000 and PostgreSQL: Record Editing Problems

From: "Joel Burton" <jburton(at)scw(dot)org>
To: Scott Teglasi <scotty(at)mediaglue(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Access 2000 and PostgreSQL: Record Editing Problems
Date: 2001-01-08 18:54:29
Message-ID: 200101081854.f08IsU615665@olympus.scw.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 5 Jan 01, at 14:37, Scott Teglasi wrote:

> When I add a record, I fill in the relevant fields, but when I
proceed
> to the next row, the row I just added shows "#Deleted" in all of
the
> columns. It continues to do this as I add records. When I close
the
> table, then reopen it, my data is there, and the #Deleted is gone.
It
> does add the data, however when adding new records, and having
> #Deleted shown on my newly added rows, is a bit of a nuisance..
> Anyone have any remedies?

It's a FAQ: www.scw.org/pgaccess.

BTW, questions about Pg + Access are better in pgsql-interfaces,
which deals with interfaces to PostgreSQL.

good luck,

--
Joel Burton, Director of Information Systems -*- jburton(at)scw(dot)org
Support Center of Washington (www.scw.org)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Webb Sprague 2001-01-08 19:26:05 Tuning questions, and an offer
Previous Message Tom Lane 2001-01-08 17:31:57 Re: ECPG could not connect to the database.