Issue with Money field using ODBC to Access database

Hello,

We are using Postgres 9.5 and ODBC ANSI driver version 9.05.01.00

We are receiving the following error message:

ODBC-update on a linked table 'tblMembers' failed

ERROR: operator does not exist: money = double precision;

Error while executing the query

This occurs when we attempt to Update a recordset to a table that contains a
Money field using either:

1) Dao from within Delphi , or

2) From within Access97 itself

Note that we are not actually updating the Money field or referring to it in
any way in the query; We are updating a Text field but the table happens to
contain a Money field. (However, the same error occurs if we do attempt to
update the money field)

The PostgreSQL Money field maps to a Double in Access.

Note: This is NOT an issue when using the 9.03.xx ODBC driver; In that case
it also maps as a double and the same query/recordset update, works
perfectly fine.

Regards,

John Van De Giessen

Thyme software