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
1) Configuration
Basically, my tables are built with SERIAL indexes and timestamp values as
described in http://www.scw.org/pgaccess/faq.html.
ODBC configuration is : Disable generic Optimizer=Yes , Recognize unique
indexes = Yes, KSQO = Yes, Logging = Yes. Everything else = No.
The database has 70 tables. Only one table will not allow updating. All
queries run within forms.
The problematic table has 5000 rows, 50 fields. No trigger is running
behind this table.
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 ?
d) The other tables seem to work well as they have less fields and records
e) Passthrough queries work perfectly.
Good, but a lot of rewriting is needed client-side.
What to you recommend : migrate to Passthrough queries or wait until the
odbc driver is fixed ?
Any idea ? Well, it seems I need help from my friends ...
Greetings from Jean-Michel POURE, Paris