My local machine: Windows 7, 32-bit. I have installed on it the psqlODBC for 32-bit. MS Access is 32-bit as well. I have tried both Unicode and Ansi connections to…
The server: a 64-bit Ubuntu, and the PostgreSQL database I want to link Access to is SET SERVER_ENCODING TO LATIN1; because I am Spanish and the data this DB will be storing requires the server to be able to handle our characters and, correct me if I'm wrong, UTF-8 does not do that.
The database works, access works, and everything is just fine as long as I don't ask Access to retrieve and link a table stored in PostgreSQL which fields have accented characters (such as 'ó'). This is: I can link tables that have no fields with accented characters, and I cannot link tables that contain fields with accented characters. HOWEVER, there is no problem when the records contain accented characters: I can both enter them from Access and read them from Postgre back into Access.
Anyone knows the reason behind this weird behaviour? I can live without accented field names but it's really bugging me…
Best Answer
Alright, so the actual problem was not related to the accented or special characters. The issue was with this certain field, namely
"Cód. Requerimiento". That dot (.) was the problem: removed it and everything is awesome now :)