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

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