From: Byron Nikolaidis <byronn@solipsys.com>
To: Khristos I. Khoury <ikhoury@user1.stritch.edu>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] I am new to this
Date: Fri, 07 May 1999 15:21:24 -0400
Message-ID: <37333D34.F25DB2E8@solipsys.com> (raw)
References: <Pine.BSF.4.05.9905071051460.11974-100000@user1.stritch.edu>
"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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: byronn@solipsys.com, ikhoury@user1.stritch.edu
Subject: Re: [INTERFACES] I am new to this
In-Reply-To: <37333D34.F25DB2E8@solipsys.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox