Connecting to database via ODBC

[torunsu]

Hi!



I am working with an Access 2003 application, which consists of some linked tables. These are linked via ODBC. My question is: Is there any way to edit the odbc connection for all of these instead of changing for each linked table? If I want to change the database this is very time consuming. I do not want to change the odbc configuration on the computer itself.

[boblarson]

All you need to do is to open the Linked Table Manager, and select all of the ODBC linked tables and then check the box to prompt for new location and then it will give you the dialog where you can select the DSN you want for those. I'm not sure what you mean by "for all of these instead of changing for each linked table."

[torunsu]

I figured it out, and that is the solution I came up with. Thanks anyway!