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

[Adrian Klaver]

On 10/29/2015 05:00 AM, John J. Turner wrote:

On Oct 29, 2015, at 6:14 AM, Killian Driscoll  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…


You should not have to make a new connection. Just use the linked table 
manager to find the new table and link to it. Access will add the schema 
to the beginning of the name. Then in the properties of the form change 
the table name in the Source field. Once you are sure everything works 
you can unlink the old table. You can always just create some dummy 
tables to test before you try the above. Linked tables definitions are 
pretty static, I find I have to relink anytime there is a change in a 
table.




-John







--
Adrian Klaver
adrian.kla...@aklaver.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

[John J. Turner]

On Oct 29, 2015, at 6:14 AM, Killian Driscoll  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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

[Killian Driscoll]

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