From: JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>
To: 'pgsql-interfaces@hub.org' <pgsql-interfaces@hub.org>
Subject: msaccess97 odbc insert problems
Date: Tue, 27 Apr 1999 17:51:29 -0400
Message-ID: <01BE90D6.94B14840.jt-kirkpatrick@mpsllc.com> (raw)
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
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: msaccess97 odbc insert problems
In-Reply-To: <01BE90D6.94B14840.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