RE: MS Access97 Postgres ODBC problems

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