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
PMTo: '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.
Thisis 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
