pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>
To: 'pgsql-interfaces@hub.org' <pgsql-interfaces@hub.org>
Subject: RE: is the odbc driver or me inconsistent??
Date: Tue, 4 May 1999 13:09:16 -0400
Message-ID: <01BE962F.514D43C0.jt-kirkpatrick@mpsllc.com> (raw)

ok, it's working now.  i don't know what is going on, but my odbc driver 
somehow reverted to "read-only".  i had to uncheck those boxes (in both 
driver and connection) for read-only, delete the links to the tables, and 
then re-link.  i'm the only one on this machine, and i haven't changed 
those settings.  i think the solution is to make the front-end to this in 
something else besides access!  has this ever happened to you???

jt
**********************
rhlinux5.2/postgres 6.4.2, odbc 6.40.5xxxxx, win98/access97

many tables created and working fine -- able to modify, insert, etc. either 
directly into the table or through queries.

but now. . .

create table testing (
	f1 int4 primary key,
	f2 char(6)
	);

i link to the table in access97, open it by double-clicking directly on the 
link, and it comes up as a table that is not updateable (which also means 
that i cannot insert a record either).  The other tables linked still work 
fine.  any ideas?  i am trying to solve the problem of not being able to 
insert or update a table that has two fields as a primary key.  but it 
looks like something has gone wrong -- i can't even insert or update this 
simple table!

jt


view thread (2+ messages)

Message-ID: <01BE962F.514D43C0.jt-kirkpatrick@mpsllc.com>
Permalink:  ../01BE962F.514D43C0.jt-kirkpatrick@mpsllc.com/
Also on:    postgresql.org/message-id/01BE962F.514D43C0.jt-kirkpatrick@mpsllc.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: jt-kirkpatrick@mpsllc.com, pgsql-interfaces@hub.org
  Subject: RE: is the odbc driver or me inconsistent??
  In-Reply-To: <01BE962F.514D43C0.jt-kirkpatrick@mpsllc.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