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

RE: MS Access97 Postgres ODBC problems

From: Michael Davis <mdavis(at)sevainc(dot)com>
To: "'Tom(dot)Bakken'" <Tom(dot)Bakken(at)tx(dot)usda(dot)gov>, "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: RE: MS Access97 Postgres ODBC problems
Date: 2001-05-04 18:26:28
Message-ID: (view raw or whole thread)
Lists: pgsql-odbc
Is the primary key of the table you are updating in the data displayed on 
the form?  Access has interesting issues when the primary key is not a part 
of data being inserted and/or updated.

-----Original Message-----
From:	Tom.Bakken [SMTP:Tom(dot)Bakken(at)tx(dot)usda(dot)gov]
Sent:	Thursday, May 03, 2001 4:09 PM
To:	pgsql-odbc(at)postgresql(dot)org
Subject:	[ODBC] MS Access97 Postgres ODBC problems

I'm using postgres 6.5.2 on Red Hat Linux 6.1  When updating tables in
Access97 on a Windows NT 4.0 we've been getting '#deleted's showing up
on records we're adding to a table.

I've run vacuum on the tables in question and the system tables.  The
problem won't go away.

Otherwise the system works great.

Tom Bakken
Information Resource Manager
USDA, Rural Development
101 South Main, Suite 102
Temple, TX 76501

Phone: 254-742-9726 Fax: 254-742-9709
Email: tom(dot)bakken(at)tx(dot)usda(dot)gov

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster


pgsql-odbc by date

Next:From: Tom.BakkenDate: 2001-05-04 18:33:27
Subject: Re: I saw a table that wasn't there
Previous:From: Hiroshi InoueDate: 2001-05-04 15:15:31
Subject: RE: Writing Large Objects to Postgresql via ODBC using VB

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