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

Поиск
Список
Период
Сортировка
От Killian Driscoll
Тема How can I change defined schema of linked tables when using Access linked table manager odbc connection
Дата
Msg-id CAL64pZOZYwa=ermHybyK9V=YjDO=UtkPOq-3UApHZjV8VvsU3Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: How can I change defined schema of linked tables when using Access linked table manager odbc connection  ("John J. Turner" <fenwayriffs@gmail.com>)
Список 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
www.lithicsireland.ie
ca.linkedin.com/in/killiandriscoll

В списке pgsql-general по дате отправления:

Предыдущее
От: Eelke Klein
Дата:
Сообщение: ftell mismatch with expected position
Следующее
От: "John J. Turner"
Дата:
Сообщение: Re: How can I change defined schema of linked tables when using Access linked table manager odbc connection