How do I change the connection settings for an MS Access Database linking to a moved SQL Server database?
I have inherited a SQL server database which has a MS Access in a mdb file. Using Backup and Restore I have moved the SQL database across to another machine running SQL Server Express 2008. I can connect to this fine using the Microsoft SQLServer Management Studio, browse data etc.
I have copied the Access mdb file to the new machine but cannot figure out how to update the server settings for the database on the new machine it is dealing with. I can see in the tool tip that comes up when I hover over a table name that it wants to point to the old server, but can't see any properties/configuration settings detailing how to change this.
I have copied the Access mdb file to the new machine but cannot figure out how to update the server settings for the database on the new machine it is dealing with. I can see in the tool tip that comes up when I hover over a table name that it wants to point to the old server, but can't see any properties/configuration settings detailing how to change this.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OK - trying the thing I was doing above - Database Tools - Linked Table Manager - select all the tables that come up and when the error message comes up change the values seemed to work one time when it hadn't worked before. Not sure what was different. Makes you long for the good old command line.
ASKER
Seems like there should be a neater solution then just waiting for Access to throw up an error message to change the setttings, which then doesn't work straightaway.
ASKER