How can I change defined schema of linked tables when using Access linked table manager odbc connection

[Killian Driscoll <killiandriscoll@xxxxxxxxx>]

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

academia.edu/KillianDriscoll
www.lithicsireland.ie
ca.linkedin.com/in/killiandriscoll