Switching Access ADP file to different SQL database
Posted on 2004-08-10
I have an Access database project (.adp) file which I copied from my home computer to the server here at the office. The Access forms and views were all designed to work with a SQL database at home that is the same as the one here on the server.... except that the SQL Server name is different, so the adp file says it is disconnected from its underlying SQL database. Which, of course, it is. Is there a way to get the Access adp to "switch" to the local SQL database here on the server?