How do you set search path to schema in Postgresql using ODBC in MS Access? How do you set search path to schema in Postgresql using ODBC in MS Access? postgresql postgresql

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.

Connection Options - Correct String