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.Bakken@tx.usda.gov]
Sent: Thursday, May 03, 2001 4:09 PM
To: pgsql-odbc@postgresql.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.bakken@tx.usda.gov
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster