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

Поиск
Список
Период
Сортировка
От John J. Turner
Тема Re: How can I change defined schema of linked tables when using Access linked table manager odbc connection
Дата
Msg-id 2E918C0E-7994-492C-A732-99622133006D@gmail.com
обсуждение исходный текст
Ответ на How can I change defined schema of linked tables when using Access linked table manager odbc connection  (Killian Driscoll <killiandriscoll@gmail.com>)
Ответы Re: How can I change defined schema of linked tables when using Access linked table manager odbc connection
Список pgsql-general
On Oct 29, 2015, at 6:14 AM, Killian Driscoll <killiandriscoll@gmail.com> 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
theschema from 'public' to 'irll'. The linked table in Access are still linked as 'public' and I need to update/change
theconnection 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
haveset 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
linkedtable manager in Access? 

You can swap the existing linked table objects to their new connection…

-John




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

Предыдущее
От: Killian Driscoll
Дата:
Сообщение: How can I change defined schema of linked tables when using Access linked table manager odbc connection
Следующее
От: Will McCormick
Дата:
Сообщение: BDR-Plugin make install on RHEL7.1