I am using postgresql 9.3 on Windows 8 64, and am using Access as a frontend data entry. In postgresql I have changed the schema from 'public' to 'irll'. The linked tables in Access are still linked as 'public' (e.g. 'public_table1') and I need to update/change the connection of the tables to match the new schema in the postgresql db (e.g. 'irll_table1').
Using the linked table manager, I cannot see an option to change the old schema prefix of 'public' to the new of 'irll'.
I can easily set up a new odbc connection with the new schema, but if I do this I will lose the data input forms I have set up in the Access database. How can I change the defined schema of the linked tables?