Linked Tables, Changing from Production DSN to Test DSN

Question

Post reply

Linked Tables, Changing from Production DSN to Test DSN

Robert Wetherill

Right there with Babe

Points: 790
More actions
September 20, 2005 at 3:08 pm

#363695

Hi,
Is there an easy way to change a linked table from a production DSN to a test DSN? Looks like I have to delete the link from the production DSN and re-add the table from the test DSN. Any ideas?

Thanks,
Bob

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Cory Perkins SSChasing Mays Points: 638 More actions · Answer 1

You can use the linked table manager and select the check box at the bottom that says Always prompt for new location.

DKeeling Old Hand Points: 385 More actions · Answer 2

I have never been able to get the Linked Table manager to work with ODBC linked tables as it always halys with an error message.

Naeem Azizian Newbie Points: 9 More actions · Answer 3

hi,

try this link, hope it helps!

http://www.sqlservercentral.com/columnists/awarren/dsngen.asp

Mike Jensen-169059 SSC Enthusiast Points: 113 More actions · Answer 4

I have a module, tables and forms which will perform this for you dynamically and much easier to use than the linked table manager. If you want it, I will provide it for free just send me a request. You just insert the code into the app and add a couple of lines on your splash, login or main menu forms and it will check the attachments everytime the application starts. Way cool.

mjensen@plexent.com

Bill Holt Mr or Mrs. 500 Points: 527 More actions · Answer 5

For what it is worth, moving to an .adp as I did just recently makes this far easier. You simply change the connection string from the menu File|Connection...

There are some disadvantages to using the .adp but overall, I believe the advantages outweigh them.

Robert Wetherill Right there with Babe Points: 790 More actions · Answer 6

Robert Wetherill

Right there with Babe

Points: 790

September 25, 2005 at 5:08 am

#592861

Thanks I will try this. What exactly is a ".adp" ???

Bill Holt Mr or Mrs. 500 Points: 527 More actions · Answer 7

Sorry, an .adp is a Microsoft Access Project as opposed to a .mdb which is a database. Since you are dealing with sql data, if you have no need of local storage, you can build a project instead of a database. I believe projects started up with Access 2000.

I have just started using .adps instead of .mdbs because there are several advantages. I use Access as a front-end to sql and a project is just that. Any queries you build are saved as either Views or Stored Procedures. I use views and stored procedures now all the time instead of Access queries because they are much, much faster.

Executing stored procedures with parameters is also much easier in a project.

The disadvantages are: no local tables (no big deal if everything is on the sql server anyway), queries are not stored locally but on the sql server (no big deal if you don't have users building their own queries that would just clutter up the sql server if saved there).

Hope that helps,

Robert Wetherill Right there with Babe Points: 790 More actions · Answer 8

Thanks, that helps alot.

Problem is that I am debugging an application developed by another guy and the code is all over the place. There are some local "temporary" tables which I should move to SQL Server. It's a real pain deploying this application to different users when you have local tables.

Thanks again!!