I am using Access 2010 on a migration project to SQL Server 2008. In my development server I have imported all the necessary tables and have created external links to them within the Access databases to be converted. I figured I would use a file-based DSN so that I could easily change the location of the dev server to the production server when it was time to do so.
But my strategy seems to not be able to work. I changed the file based DSN and used the Linked-Table Manager to reset the links but the links on each of the tables still points to my developement database server.
Is there anyway to accomplish this task without manually relinking the hundreds of tables involved in the migration?