How do you set search path to schema in Postgresql using ODBC in MS Access?
The problem boiled down, as I thought, to a syntax error. Of course, the error thrown by MS Access doesn't say anything about that, but it is.
Here is a capture of the string that works. Please note the semicolon ;
at the end of the SET search_path
string.