I see that you need to remove two lines of code that was for our application that stored the current link in one of our tables named "System"

Remove the following...

You might like to look at the answer I put in a previous question this week at http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=131&messageid=322662.

This code 1. removes all links, 2. asks for the DSN...

Here is the code that we use to connect to all the tables in a SQL database. This does not attach to views. Hope this helps.

Bob

Sub Attach()

    DoCmd.Hourglass True

   ...