pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
msaccess97 odbc insert problems 2+ messages / 2 participants [nested] [flat]
* msaccess97 odbc insert problems @ 1999-04-27 21:51 JT Kirkpatrick <jt-kirkpatrick@mpsllc.com> 0 siblings, 0 replies; 2+ messages in thread From: JT Kirkpatrick @ 1999-04-27 21:51 UTC (permalink / raw) To: 'pgsql-interfaces@hub.org' <pgsql-interfaces@hub.org> Hey all, thanks for helping me understand that my tables need to have a unique index in order to be able to insert records in msaccess97 through the odbc driver. I corrected that problem in the table. Now, from within access97, if I make my form link directly to the table, I can add records no problem. But I need to link my form to the results of a query that contains a field from another table (linked to the main one). When I do that, I cannot insert new records. Also, if I remove the second table so the query only has the main table (which I can insert records into directly), it won't let me insert records. This is a little frustrating - I have another table set up the same way (with only the main table in a query) and the query WILL let me insert records into it. I don't find anything on this in the odbc driver faq. Does anyone have any idea what could be going on? Hopefully one day I'll be able to contribute to this list rather than take take take! I surely appreciate all the responses to my previous problems! So far I have been able to solve all of them (up to this one) with your help. Thanks! jt ^ permalink raw reply [nested|flat] 2+ messages in thread
* RE: [INTERFACES] msaccess97 odbc insert problems @ 1999-04-27 22:22 Michael J Davis <michael.j.davis@tvguide.com> 0 siblings, 0 replies; 2+ messages in thread From: Michael J Davis @ 1999-04-27 22:22 UTC (permalink / raw) To: 'JT Kirkpatrick' <jt-kirkpatrick@mpsllc.com>; 'pgsql-interfaces@hub.org' <pgsql-interfaces@hub.org> There are certain types of linked tables in Access97 where Access will not allow updates. I have successfully updated tables that have been linked together. This includes both local Access97 tables and PostgreSQL tables.. I would have to suggest that this is an Access97 issue. Turn on the logging facility in the PostgreSQL ODBC driver look at c:\psql_odbc???.sql. This could shed some light on the issue. I find the PostgreSQL odbc log file very useful in resolving issues. -----Original Message----- From: JT Kirkpatrick [SMTP:jt-kirkpatrick@mpsllc.com] Sent: Tuesday, April 27, 1999 3:51 PM To: 'pgsql-interfaces@hub.org' Subject: [INTERFACES] msaccess97 odbc insert problems Hey all, thanks for helping me understand that my tables need to have a unique index in order to be able to insert records in msaccess97 through the odbc driver. I corrected that problem in the table. Now, from within access97, if I make my form link directly to the table, I can add records no problem. But I need to link my form to the results of a query that contains a field from another table (linked to the main one). When I do that, I cannot insert new records. Also, if I remove the second table so the query only has the main table (which I can insert records into directly), it won't let me insert records. This is a little frustrating - I have another table set up the same way (with only the main table in a query) and the query WILL let me insert records into it. I don't find anything on this in the odbc driver faq. Does anyone have any idea what could be going on? Hopefully one day I'll be able to contribute to this list rather than take take take! I surely appreciate all the responses to my previous problems! So far I have been able to solve all of them (up to this one) with your help. Thanks! jt ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1999-04-27 22:22 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 1999-04-27 21:51 msaccess97 odbc insert problems JT Kirkpatrick <jt-kirkpatrick@mpsllc.com> 1999-04-27 22:22 RE: [INTERFACES] msaccess97 odbc insert problems Michael J Davis <michael.j.davis@tvguide.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