Moving database location 1

[fawkes]

I have an ADP file I've created on my work computer linked to a database on the sqlserver located on the work server.

I've taken a backup of the database and restored it on my home computer with the sqlserver express edition so I can do some work at home.

I've also taken a copy of the ADP file.

How do I get the ADP file to see the database in it's new location?

 

[ajrimmer]

You need to change the connection. In Access 2003 goto File - Connection & amend appropriately. If you're using Access 2007 it's a bit more complicated & is described here: http://support.microsoft.com/kb/306881

 

[fawkes]

Thanks for the answer, I was looking under the 'Database' menu option and couldn't find anything.

Big star for you )