Link to new database location

[krhoover]

ADuring a system upgrade, our database was migrated to a new server. How do I change Access 2007 to link to the new location instead of defaulting to the old location?

[ssanfu]

Use the "Linked Table Manager".
In A2010, it is under the "External Data" menu option. My A2007 is at home, so I can't tell you how to get to the manager.

Be sure to check the "Always prompt for new location" check box.

[krhoover]

Thank you!