Change ODBC within MSAccess to point to a different instance

[TG4600, DK]

Is it possible to change the ODBC-Connection within MSAccess to point to af
different instance of my oracle-database?

I have already setup ODBC via ODBC Data Source Administartor, but I want to
change the source from within MS Access

 

[Alex Dybenko]

Hi,
to relink tables - check this:
http://www.mvps.org/access/tables/tbl0010.htm

actually - there is no need in DSN entry, just use DSN-less connection:
http://www.accessmvp.com/djsteele/DSNLessLinks.html

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[david]

You may have problems trying to change a DSN used with Access.

Access caches extra connection information, and sometimes even when
you use a DSN you also have to remove all the links and re-create them.

(david)