The current config is like this:
Access 2007 db DATA contains all the tables.
Access 2007 db APP has all the forms, queries, reports.
APP uses linked tables from DATA.
I used the SS Move Data tool to export the data from DATA to the SqlServer database. That went smoothly.
Now I want to update the links in APP to the Sql Server tables. When I try to use Linked Table Manager it seems to only work on Access tables.
Is there an automated way to change the links from Access tables to SS tables?