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 LAA14955; Tue, 27 Apr 1999 11:47:47 -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 LAA14732; Tue, 27 Apr 1999 11:46:52 -0400 Received: by localhost with Microsoft MAPI; Tue, 27 Apr 1999 11:49:35 -0400 Message-ID: <01BE90A4.053EF180.jt-kirkpatrick@mpsllc.com> From: JT Kirkpatrick To: "'Byron Nikolaidis'" , JT Kirkpatrick Cc: "'pgsql-interfaces@hub.org'" , "'pgsql-admin@hub.org'" Subject: RE: [INTERFACES] recordset not updateable Date: Tue, 27 Apr 1999 11:49:33 -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 I'll upgrade the odbc driver, but this version seems to be working on the other tables. To answer your question about a unique index, NO. have I missed it?? Does every table need a unique index for the odbc driver to work properly?? jt -----Original Message----- From: Byron Nikolaidis [SMTP:byronn@insightdist.com] Sent: Monday, April 26, 1999 8:40 PM To: JT Kirkpatrick Cc: 'pgsql-interfaces@hub.org'; 'pgsql-admin@hub.org' Subject: Re: [INTERFACES] recordset not updateable JT Kirkpatrick wrote: > this is a resubmit with my pdbc log file. It shows an error in finding > the file MsysConf. Maybe this is the problem?? Can someone please provide > some insight? Thanks! > The MsysConf is NOT the problem. It is an *optional* config file for the Jet Database engine (which Access uses). Do you have a unique index on the table? Check the FAQ carefully at our site also: http://www.insightdist.com/psqlodbc Also, you may want to upgrade the odbc driver also. Your version is 6.30.0250 and the newest is 6.40.0005 or something like that. Byron