How can I edit linked tables in access to change the DSN?

J

John W. Vinson

I need to change the DSN on linked tables. How do I do that?
Click to expand...

Simplest would be just to delete the links (the table icons), and use File...
Get External Data... Link to link to the new DSN.
 

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

Similar Threads

Finding the backend tables for a front end ? 4
Linked tables to SQL 1
How to Upgrade SQL back end of Access linked tables. 7
how to avoid login prompt for Linked Tables thru DSN entry? 1
Linked Oracle Table in Access 1
ConnectionString without DSN not working 0
Linked table sometimes has all ODBC parameters 1
Linked Tables refer to previous ODBC connection parameters 1

Top