RE: [INTERFACES] msaccess97 odbc insert problems

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(at)mpsllc(dot)com]
Sent: Tuesday, April 27, 1999 3:51 PM
To: 'pgsql-interfaces(at)hub(dot)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