Auto re-linking tables in a database

M

Miguel Velez

We have a very large Oracle database and many Ms Access
applications which link to tables in that database. Each
Ms Access application has a different combination of
tables linked.

We're in the process of upgrading the server on which the
Oracle database is stored. The new server will have a new
name on the network and, therefore, all the Ms Access
aplications will need to ahve their tables re-linked to
the new location.

Is there some sort of automated way that we can do this?
We don't really want to have to go manually into each
application and re-linking each affected table.

Miguel
 

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