Received: from s20.highertech.net (root@s20.highertech.net [209.54.120.20]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA87558 for ; Tue, 4 May 1999 12:40:05 -0400 (EDT) (envelope-from jt-kirkpatrick@mpsllc.com) Received: from kirkpatrickjt (whiteoak-34.highertech.net [209.140.56.34] (may be forged)) by s20.highertech.net (8.8.6/8.8.6) with SMTP id MAA31579 for ; Tue, 4 May 1999 12:39:42 -0400 Received: by localhost with Microsoft MAPI; Tue, 4 May 1999 12:42:06 -0400 Message-ID: <01BE962B.84B706A0.jt-kirkpatrick@mpsllc.com> From: JT Kirkpatrick To: "'pgsql-interfaces@hub.org'" Subject: is the odbc driver or me inconsistent?? Date: Tue, 4 May 1999 12:42:03 -0400 Organization: MPS, LLC X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit rhlinux5.2/postgres 6.4.2, odbc 6.40.5xxxxx, win98/access97 many tables created and working fine -- able to modify, insert, etc. either directly into the table or through queries. but now. . . create table testing ( f1 int4 primary key, f2 char(6) ); i link to the table in access97, open it by double-clicking directly on the link, and it comes up as a table that is not updateable (which also means that i cannot insert a record either). The other tables linked still work fine. any ideas? i am trying to solve the problem of not being able to insert or update a table that has two fields as a primary key. but it looks like something has gone wrong -- i can't even insert or update this simple table! jt