Received: from net1.wellthot.com (root@net1.wellthot.com [205.164.35.35]) by hub.org (8.9.2/8.9.1) with ESMTP id IAA51002 for ; Tue, 2 Mar 1999 08:05:51 -0500 (EST) (envelope-from mas@wellthot.com) Received: from daffy ([192.168.2.19]) by net1.wellthot.com (8.8.8/8.8.8) with SMTP id GAA10191; Tue, 2 Mar 1999 06:53:20 -0600 (CST) (envelope-from mas@wellthot.com) Message-ID: <02e601be64ad$50572200$1302a8c0@daffy.wellthot.com> From: "Mark A. Schwenk" To: , Subject: Re: [INTERFACES] Read-Only ODBC, MS/ACCESS Date: Tue, 2 Mar 1999 07:04:44 -0600 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 It seems that the ODBC driver creates a read-only connection by default (at least with Access). You need to turn this off as follows. Try to create a new ODBC link from Access to PostgreSQL. When you see the PostgreSQL Driver Setup dialog, click the Driver button in the the Options (Advanced). This will open an Advanced Options (Driver) dialog. In this dialog box, uncheck the ReadOnly (Default) checkbox. I hope this solves your problem. -Mark Schwenk WellThot Inc. http://wellthot.com -----Original Message----- From: Nicolas Boretos To: pgsql-interfaces@hub.org Date: Tuesday, March 02, 1999 3:50 AM Subject: [INTERFACES] Read-Only ODBC, MS/ACCESS >Hello, > >I am experimenting with the postdrv and seems to work in Excel, but as >read only in Acess97. Any ideas? >Thank you, >Nicolas Boretos >