Access 2002 ADP with Multiple Databases
Posted on 2002-03-23
I have several Access front ends that link tables to multiple backend databases on multiple machines. Can an adp project have tables in multiple SQL Server databases across multiple SQL Servers on multiple servers? If so, how do I do that? Whenever I try to create an adp from scratch it only allows me to specify one SQL Server instance. Also when I use linked tables to Access backends, I can easily move the backend to a differnt folder or server and then re-attach the tables. Once I have created an adp, how do I point it to a different SQL Server instance if I move the backend SQL Server database?