I have an Access database that I use to convert data from one ERP to another ERP system. The databases are Pervasive to Postgresql.
I link tables from both databases using ODBC and then have append queries to migrate the data.
My problem is that I take this database to different servers and it is very cumbersome to update the links individually in the linked table manager. How can I mass update the links? In total I link to about 40 tables.