how to reconfigure Table links in MS Access 2003.

[robertvlee]

We have an Access application using several DSN ODBC connection to
connect to several database both MSSQL and Oracle9. The person created
this Access frontend left the company, and the Oracle and MSSQL are
both changed the password and some table.

I am not very good at Access, so where in Access that I can fix the
ODBC link to all these tables to use the correct DSN connections, or
where I can just change the ID and password of the DSN ODBC connection.

I seem to me that this front-end Access program still keeps the old
configuration so all the queries and reports of it still not working.

Thank you very much.

-Robert

 

[Bill Mosca, MS Access MVP]

The simplest way is to create a enw ODBC DSN file or open the one you have
in NotePad and edit it, but that could turn it into mush if you don't edit
correctly.

To reset your links, click on Tools>Database Utilities>Linked table manager.
When the dialog box opens, check the "Always prompt for a new location" box
in the lower left corner. Select your tables and click OK. You will be
prompted to select a target. The ODBC file type is the last one in the
dropdown list.

 

[aaron.kempf]

any MDB developer worth his beans-- there aren't very many-- would also
use SQL passthrough queries..

and you'll probably need to update the connection strings on the Sql
passthroughs also

-Aaron

 

[robertvlee]

The simplest way is to create a enw ODBC DSN file or open the one you have
in NotePad and edit it, but that could turn it into mush if you don't edit
correctly.

To reset your links, click on Tools>Database Utilities>Linked table manager.
When the dialog box opens, check the "Always prompt for a new location" box
in the lower left corner. Select your tables and click OK. You will be
prompted to select a target. The ODBC file type is the last one in the
dropdown list.

Thank, I will give it a try.

-Robert