no more problems with Insight's ODBC driver and Access 97

Yesterday, I sent to the list the following request :

>
> We have a Postgres 6.3.2 database on Linux 2.0.32/RedHat 5.0. We configured
> Microsoft Access 97 on NT 4.0 workstation and the PostSQL ODBC driver from
> Insight to query the database.
>
> There's no problem to link a Postgres table in Access 97 and consult the
> database.
>
> On the other hand, if we modify a value from Access 97, Access blocks forever.

Many thanks to all of those who answered my question, either directly to me or
on the list. The solution is to change the [Use Declare/Fetch] option to
false, on the Post SQL ODBC driver configuration. Everything works well know.

Roland.

--
Roland Dirlewanger
CNRS - Délégation Aquitaine et Poitou-Charentes
Esplanade des Arts et Métiers
33402 TALENCE CEDEX

Mél : rd(at)dr15(dot)cnrs(dot)fr, Tél : 05 56 37 80 80, Fax : 05 57 96 10 56