Michael,
This sounds a lot like my ERP system. Are you using Max by chance? Max changed from Pervasive to SQL. To keep my databases going I first created a new DNS ODBC connection to the SQL files, then relinked the tables. After that, everything still worked.
Doyce
---In MS_Access_Professionals@yahoogroups.com, <duanehookom@...> wrote :
I would probably link one table in a scrap database so I could capture the connection string required. I would then use some standard relinking code to change the connection string of the old system with the connection string of the new system.
Doug Steele has some code that I use at http://www.accessmvp.com/djsteele/DSNLessLinks.html.
Regards,
Duane
Sent: Tuesday, March 13, 2018 10:59 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Moving old Access db links from Pervasive to MSSQL
Hello everyone,
I have an older Access database that I have been asked to resurrect after several years of inactivity. This database had ODBC links to several tables (named Order Master, Part Master, and Part Sales) to our company's ERP system. Since then, this ERP system has migrated from a Pervasive SQL database to an MS SQL database. I have tried using the Linked Table Manager to point the links to the SQL database, Access is unable to find the tables. All three tables have primary keys. One issue is that the ODBC database name is different in the Pervasive version vs the SQL version.
Can anyone offer any suggestions?
Thanks in advance,
Michael
Posted by: winberry.doyce@con-way.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar