Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 316
  • Last Modified:

Switching Access External Links using a file based DSN

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?
0
CSUGDEN
Asked:
CSUGDEN
  • 3
  • 2
1 Solution
 
Dale FyeCommented:
I prefer to use DSN-less connections.  Check out this link for a good explaination
0
 
CSUGDENAuthor Commented:
That sounds like it might work. I suppose that the property change 'sticks' after the one time you run it or does it have to be run every time the database is accessed?
0
 
Dale FyeCommented:
If you leave the tables linked to the front end, you would only need to run the code when you need to switch back and forth between your production and development data.

I tend to delete the linked tables from my applications when they close the application.  This means that I need to relink all of the tables each time the application starts.  It takes a little longer to load, but helps to minimize unauthorized access to the actual data.
0
 
CSUGDENAuthor Commented:
Thanks again. That seems like a great solution.
0
 
Dale FyeCommented:
glad to help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now