Received: from bastion.solipsys.com (bastion.solipsys.com [209.117.190.2])
	by hub.org (8.9.3/8.9.3) with ESMTP id PAA23715
	for <pgsql-interfaces@postgreSQL.org>;
	Fri, 7 May 1999 15:21:28 -0400 (EDT)
	(envelope-from byronn@solipsys.com)
Received: from solipsys.com ([209.117.190.166])
	by bastion.solipsys.com (8.9.1a/8.9.1) with ESMTP id PAA13068;
	Fri, 7 May 1999 15:20:22 -0400 (EDT)
Sender: byronn@solipsys.com
Message-ID: <37333D34.F25DB2E8@solipsys.com>
Date: Fri, 07 May 1999 15:21:24 -0400
From: Byron Nikolaidis <byronn@solipsys.com>
X-Mailer: Mozilla 4.5 [en] (X11; U; SunOS 5.7 i86pc)
X-Accept-Language: en
MIME-Version: 1.0
To: "Khristos I. Khoury" <ikhoury@user1.stritch.edu>
CC: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] I am new to this
References: <Pine.BSF.4.05.9905071051460.11974-100000@user1.stritch.edu>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Content-Transfer-Encoding: 7bit

"Khristos I. Khoury" wrote:

> DSN info:
> DSN='PostgreSQL',server='user3.stritch.edu',port='5432',dbase='vb5',user='ikhoury',passwd='123qwe'
>
> readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
>           conn_settings=''
>           translation_dll='',translation_option=''
>
> It says ReadOnly? On the other hand in Access it is Read-Write? Any clues?
> Thanks

Actually, readonly=0 means false, so it is NOT readonly.

If you can't update in Access, check to make sure you have a unique index on the table.  The Jet
Database Engine queries the table when you link it to make sure there is a unique index on it.  If it
is, then you should be able to update.    If the JET can't find a unique index, then it should pop up
a dialog which asks you to tell it what the unique field(s) are.

Did you see such a dialog?

Byron