Jean-Michel POURE wrote:
> Hello all,
> I have serious problems updating an attached table in access 2000.
> The problem is similar to
> 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.
In response to
pgsql-odbc by date
|Next:||From: Cedar Cox||Date: 2001-04-09 00:21:04|
|Subject: Re: Access2K Form object to use passtrough queries|
|Previous:||From: Tamsin||Date: 2001-04-06 15:38:22|
|Subject: access #s_c_h#|