Received: from s20.highertech.net (root@s20.highertech.net [209.54.120.20]) by hub.org (8.9.3/8.9.1) with ESMTP id NAA33334 for ; Tue, 27 Apr 1999 13:56:42 -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 NAA22896; Tue, 27 Apr 1999 13:55:59 -0400 Received: by localhost with Microsoft MAPI; Tue, 27 Apr 1999 13:58:42 -0400 Message-ID: <01BE90B6.0F49E060.jt-kirkpatrick@mpsllc.com> From: JT Kirkpatrick To: "'Denis Sbragion'" , "'pgsql-interfaces@hub.org'" Cc: Delain Huggins Subject: RE: [INTERFACES] win98 odbc problem? Date: Tue, 27 Apr 1999 13:58:41 -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 Ah hah, that is the problem. Thanks very much! jt -----Original Message----- From: Denis Sbragion [SMTP:sbragion@email.com] Sent: Saturday, April 24, 1999 4:51 AM To: JT Kirkpatrick; 'pgsql-interfaces@hub.org' Cc: Delain Huggins Subject: Re: [INTERFACES] win98 odbc problem? Hello, At 15.37 23/04/99 -0400, you wrote: >I have two databases, oidetail and dispnotes: >Create table oidetail ( > Autoinv int4 not null, > Partnum char(6) not null check (partnum<>' '), ... > Oldrtrn bool default 1, > Oldrtrndt date > Constraint ssmsoidetail foreign key (autoinv) references ssms); it looks like this table doesn't have a primary key. Access, and VB and any other Microsoft program that uses the MS Jet DB Engine, doesn't let you add records on a table that doesn't have at least one unique index on it. Bye! -- Sbragion Denis InfoTecna Tel, Fax: +39 039 2324054 URL: http://infotecna.home.dhs.org