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

Hello all,

Thank you for your quick answers and help.

Surprise : after a discussion with Bill Gates, CIA's most rewarded agent, I
updated to Jet 4 SP3 which solved all problems.
It seems like MDAC 2.6 and Jet4 SP3 should always be used in conjunction.

Furthermore, I also converted my application to pass-through queries.
Cedar : thanks for your code, I am waiting for it. I will also post mine
when fully tested.

Greetings from Jean-Michel POURE, Paris

At 08:51 09/04/01 +0900, you wrote:
>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