On Oct 29, 2015, at 6:14 AM, Killian Driscoll <killiandriscoll@xxxxxxxxx> wrote: > 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? This sounds more like an Access question, so an inquiry to an Access forum may be more fruitful, but have you tried the linked table manager in Access? You can swap the existing linked table objects to their new connection… -John -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
