how to reconfigure Table links in MS Access 2003.


R

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
 
Ad

Advertisements

B

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.
 
A

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
 
Ad

Advertisements

R

robertvlee

Bill said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top