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

From: Killian Driscoll <killiandriscoll(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: How can I change defined schema of linked tables when using Access linked table manager odbc connection
Date: 2015-10-29 10:14:39
Message-ID: CAL64pZOZYwa=ermHybyK9V=YjDO=UtkPOq-3UApHZjV8VvsU3Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 <https://ucd.academia.edu/KillianDriscoll>
www.lithicsireland.ie
ca.linkedin.com/in/killiandriscoll

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John J. Turner 2015-10-29 12:00:01 Re: How can I change defined schema of linked tables when using Access linked table manager odbc connection
Previous Message Eelke Klein 2015-10-29 09:51:35 ftell mismatch with expected position