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.