Solved

Switching Access External Links using a file based DSN

Posted on 2012-03-20
5
309 Views
Last Modified: 2012-03-21
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
Comment
Question by:CSUGDEN
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 48

Expert Comment

by:Dale Fye (Access MVP)
ID: 37746652
I prefer to use DSN-less connections.  Check out this link for a good explaination
0
 

Author Comment

by:CSUGDEN
ID: 37746761
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
 
LVL 48

Accepted Solution

by:
Dale Fye (Access MVP) earned 300 total points
ID: 37746856
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
 

Author Closing Comment

by:CSUGDEN
ID: 37747525
Thanks again. That seems like a great solution.
0
 
LVL 48

Expert Comment

by:Dale Fye (Access MVP)
ID: 37747548
glad to help
0

Featured Post

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question