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

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

"TG4600, DK" <(E-Mail Removed)> wrote in message
news:7D95B861-B947-4235-8061-(E-Mail Removed)...
> 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
>

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)

"TG4600, DK" <(E-Mail Removed)> wrote in message
news:7D95B861-B947-4235-8061-(E-Mail Removed)...
> 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
>