Received: from mail.tol.it (mail.tin.it [194.243.154.49]) by hub.org (8.8.8/8.7.5) with ESMTP id GAA08525 for ; Mon, 27 Apr 1998 06:09:09 -0400 (EDT) Received: from Server.InfoTecna.com (Monza4-28.tin.it [195.31.128.27]) by mail.tol.it (8.8.4/8.8.4) with ESMTP id MAA14907 for ; Mon, 27 Apr 1998 12:08:51 +0200 (MET DST) Received: from tm3.InfoTecna.com (Tm1.InfoTecna.com [192.168.1.1]) by Server.InfoTecna.com (8.8.5/8.8.5) with SMTP id MAA03317 for ; Mon, 27 Apr 1998 12:08:51 +0200 Message-Id: <3.0.5.32.19980427120850.007e6320@MBox.InfoTecna.com> X-Sender: denis@MBox.InfoTecna.com (Unverified) X-Mailer: QUALCOMM Windows Eudora Light Version 3.0.5 (32) Date: Mon, 27 Apr 1998 12:08:50 +0200 To: pgsql-interfaces@postgreSQL.org From: Sbragion Denis Subject: VB and ODBC: found Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Hello, after a fast look I found a reference in the MS knowledge base: http://support.microsoft.com/support/kb/articles/q109/8/00.asp little excerpt: Before you can edit an external ODBC table, the table must contain a unique index. If you get the following error message, you might not have a unique index on the table: Can't perform operation; it is illegal. You could also receive this error if the Data1.Recordset.Updatable flag is not set to True. Also, if you set the Data1.Options property to 64 (SQL_PASSTHROUGH), the data control will not be updatable. Hope it helps. Bye ! Dr. Sbragion Denis InfoTecna Tel, Fax: +39 39 2324054 URL: http://space.tin.it/internet/dsbragio