I have a primary key which is int and the rest varchar
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, May 09, 2001 8:18 AM
To: Chris Gray
Cc: Peter Wilkinson; Hiroshi Inoue; Jean-Michel POURE; Keith Todd;
pgsql-odbc@postgresql.org
Subject: Re: [ODBC] ODBC and Access 2000
Chris Gray <cpgray@library.uwaterloo.ca> writes:
> Still no luck. I tried making all fields non null and supplying a default
> value and still get the same error message.
I'm not an Access user, but I have a vague recollection that it has
problems with updating rows in tables that don't have a PRIMARY KEY
declared. There is more about this in our mailing list archives.
regards, tom lane