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: 01C0D495.762844A0.mdavis@sevainc.com (view raw or flat)
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


Responses

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-2014 The PostgreSQL Global Development Group