pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
is the odbc driver or me inconsistent?? 2+ messages / 1 participants [nested] [flat]
* is the odbc driver or me inconsistent?? @ 1999-05-04 16:42 JT Kirkpatrick <jt-kirkpatrick@mpsllc.com> 0 siblings, 0 replies; 2+ messages in thread From: JT Kirkpatrick @ 1999-05-04 16:42 UTC (permalink / raw) To: 'pgsql-interfaces@hub.org' <pgsql-interfaces@hub.org> 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* RE: is the odbc driver or me inconsistent?? @ 1999-05-04 17:09 JT Kirkpatrick <jt-kirkpatrick@mpsllc.com> 0 siblings, 0 replies; 2+ messages in thread From: JT Kirkpatrick @ 1999-05-04 17:09 UTC (permalink / raw) To: 'pgsql-interfaces@hub.org' <pgsql-interfaces@hub.org> 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1999-05-04 17:09 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 1999-05-04 16:42 is the odbc driver or me inconsistent?? JT Kirkpatrick <jt-kirkpatrick@mpsllc.com> 1999-05-04 17:09 RE: is the odbc driver or me inconsistent?? JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>
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