Обсуждение: recordset not updateable

  this is a resubmit with my pdbc log file.  It shows an error in finding
the file MsysConf.  Maybe this is the problem??  Can someone please provide
some insight?  Thanks!

I am using rh 5.2, postgres 6.4.2, linking to postgres with access97 and
odbc driver.  I can create a simple table, link to it, open it, and access
tell me that "this recordset is not updateable".  However, I have created
many other tables in the same fashion and even much more complex and they
are just fine.  Any idea what could be going on?  This just started
happening today.  Most of the tables I created over the past few weeks are
working fine (I met one exception which has led me to create some test
tables and link to them).  BTW, I can update the table directly in psql on
the server itself with no problem, so it must be odbc or access.  But why
do the other tables still work just fine?  HELP!!!!  Where can I look??

JT

JT Kirkpatrick wrote:

>   this is a resubmit with my pdbc log file.  It shows an error in finding
> the file MsysConf.  Maybe this is the problem??  Can someone please provide
> some insight?  Thanks!
>

The MsysConf is NOT the problem.  It is an *optional* config file for the Jet Database
engine (which Access uses).

Do you have a unique index on the table?

Check the FAQ carefully at our site also:   http://www.insightdist.com/psqlodbc

Also, you may want to upgrade the odbc driver also.  Your version is 6.30.0250 and the
newest is 6.40.0005 or something like that.

Byron