Skip site navigation (1) Skip section navigation (2)

RE: pg 7.x and Access 2000 -> #deleted error

From: Michael Davis <mdavis(at)sevainc(dot)com>
To: "'Markus Wagner'" <wagner(at)imsd(dot)uni-mainz(dot)de>, "pgsql-interfaces(at)postgresql(dot)org" <pgsql-interfaces(at)postgresql(dot)org>
Subject: RE: pg 7.x and Access 2000 -> #deleted error
Date: 2001-01-22 17:51:11
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
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(at)imsd(dot)uni-mainz(dot)de]
Sent:	Monday, January 22, 2001 5:26 AM
To:	pgsql-interfaces(at)postgresql(dot)org
Subject:	pg 7.x and Access 2000 -> #deleted error


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?



pgsql-interfaces by date

Next:From: Dave MillenDate: 2001-01-22 17:54:53
Subject: Re: pg 7.x and Access 2000 -> #deleted error
Previous:From: Nicholas ChanDate: 2001-01-22 17:39:32
Subject: Re: extremely newbie questions

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group