RE: ODBC and Access 2000 - Mailing list pgsql-odbc

From Keith Todd
Subject RE: ODBC and Access 2000
Date
Msg-id GMELJODEIKLDCLGNBNLAGECFCCAA.ktodd@spiritone.com
Whole thread Raw
In response to Re: ODBC and Access 2000  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-odbc
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


pgsql-odbc by date:

Previous
From: Jean-Michel POURE
Date:
Subject: Re: encrypt odbc transactions?
Next
From: "Henshall, Stuart - WCP"
Date:
Subject: RE: ODBC and Access 2000