When I link a postgreSQL table into MS Access, Access sees data of type 'Money' as type 'Number' rather than as 'Currency'. This is visible if you pull up the design view for a linked table. As a result of this mismapping, any attempt to use Access to update records in the table results in an error.
- PostgreSQL ODBC driver version 6.40.0006
- PostgreSQL database version 6.4
- Access error message upon update attempt :
ERROR: There is more than one possible operator '=' for types 'money' and 'float8'. You will have to retype this query using an explict cast
(which is impossible as the query is generated by Access.)
- commlog file attached - I have removed the server, port, dbase, user, and passwd for security purposes - sorry, but these should not be important bits of info.