Skip site navigation (1) Skip section navigation (2)

Re: Help : serious problems with ODBC & Postgresql 7.1 RC2 &Access 2000

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Jean-Michel POURE <jmpoure(at)axitrad(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org, Schollum(at)t-online(dot)de
Subject: Re: Help : serious problems with ODBC & Postgresql 7.1 RC2 &Access 2000
Date: 2001-04-08 23:51:09
Message-ID: 3AD0F96D.DC1B9D78@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
Jean-Michel POURE wrote:
> 
> Hello all,
> 
> I have serious problems updating an attached table in access 2000.
> The problem is similar to
> http://postgresql.rmplc.co.uk/mhonarc/pgsql-odbc/2001-03/msg00020.html
> My configuration is Access 2000 SP1 / Windows NT SP5 / MDAC 2.6 /
> PostgreSQL 7.1 RC2 /  7.104 odbc driver
> 
> 2) Problem description
> 
> a) When running the query "Select * FROM tblProblematicTable;" inside a
> form, the record cannot be updated.
> On the contrary, if running "Select field1, field2, field3, etc .. FROM
> tblProblematicTable;", the record can be updated.
> It seems that the maximum number of fields is 8 to 10, no more.
> 
> b) When deleting 99% of records, updating works again, no matter the number
> of fields.
> 
> c) Logs on the client side show nothing.
> Shall I allow logging server-side ?
> 

Yes. Try running the postmaster with -d2 (and without -S)
and see what gets logged in its stderr output. 

regards,
Hiroshi Inoue

In response to

Responses

pgsql-odbc by date

Next:From: Cedar CoxDate: 2001-04-09 00:21:04
Subject: Re: Access2K Form object to use passtrough queries
Previous:From: TamsinDate: 2001-04-06 15:38:22
Subject: access #s_c_h#

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group