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: mbentfeld@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar