How to change database connection

[dima_2009]

Hi:
I have a Access application, and it is using ODBC connection. I want to change it to different ODBC. I am having a hard time finding where to change it. Can you please let me know how to do it ?

 

[AccessMSSQL]

You need to go to Control Panel > Administrative Tools > Data Sources (ODBC). Is that what you are looking for or are you trying to do it in code?

 

[AccessMSSQL]

If you are trying to re-link the tables to a different odbc and you are using Access 2007/2010 goto External Data > ODBC Database.

 

[dima_2009]

I am trying to use different datasource. I am using Access 2007. Where do to see External Data tab ?

 

[AccessMSSQL]

See attached image. You may need to use the shift key while opening the database if the menu is being hidden.

 

[dima_2009]

Thank you..Great support.