Mass update Linked Tables in Access
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.
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.
Last Comment
chaau
One of the easiest way to do this is by using DSNs for the ODBC connections. I guess you are using DSN-less option for your linked tables. Create two DSNs: pervasiveERP and postgresERP and use them for the linked tables. If you stick to the same DSN names on different machines the linked tables will work
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
@chaau
Your suggestion works for the pervasive database but not for the postgress. For the postgres database the string also includes the database name.
Like so DSN=erp;database=abc. The database name will always be the company name so that will not work.
@Gustav Brock
I'm going to try yours
Your suggestion works for the pervasive database but not for the postgress. For the postgres database the string also includes the database name.
Like so DSN=erp;database=abc. The database name will always be the company name so that will not work.
@Gustav Brock
I'm going to try yours
ASKER
The Postgres database connection string looks like this
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Got it! That works...Thanks for your help @gustav
You are welcome!
/gustav
/gustav
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
