I have an MSAccess 2007 application that currently links to SQL Server. The links were established using External Data, but I want to refresh those links depending on what SQL Server database our customer selects (production vs development). I tried using docmd.transferdatabase but encountered an error regarding an "uninstallable ISAM file." I've read that this is a known Microsoft bug. Can someone provide me an alternative solution using VBA code. Thank you!
This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.