pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (10+ messages)  latest in thread

Message-ID: <37333D34.F25DB2E8@solipsys.com>
Permalink:  ../37333D34.F25DB2E8@solipsys.com/
Also on:    postgresql.org/message-id/37333D34.F25DB2E8@solipsys.com

 · 

reply

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