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 table in Access are still linked as 'public' and I need to update/change the connection of the tables to match the new schema in the postgresql db.
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 Access. How can I change the defined schema of the linked tables?
Killian DriscoIl IRC Postdoctoral Fellow UCD School of Archaeology University College Dublin
