How do I change Access linked table DSN with C#?

Question

I am working on a program that is updating a local Access database (.mdb) using
OleDB. However, the Access Database has some linked tables using ODBC. When Access creates the linked table in Access the connection string looks like "DSN=DSNName;DATABASE=Database...
However, I want to be able to give this program away when done, so I want to be able to change the connection string from the Access linked tables to just "DSN=DSN Name" and then the DSN has the source definition for "DATABASE=" itself so it is not needed. This way, as long as the user establishes a connection with the same DSN it will work with the Access database linked table.

This was on Google Answers, but they closed before I got an answer (actually charged me the listing fee then closed the next day!).

Answer 1

Why not just change your code to use the ODBC provider, and specify ODBC in your DSN? That seems to be the obvious solution.

Answer 2

do you evenu need know your IP address? If not you need to call someone to your place and fix it