vba to relink oracle tables in msaccess 2007
Posted on 2011-09-08
I want to use msaccess 2007 linked ODBC Oracle tables with different oracle DBs e.g. dev, uat.
e.g. original msaccess link is to Oracle table schema1.tablex in SIDA. Access would call this schema1_tablex.
I want a script to relink schema1_tablex to e.g. schema2.tablex in SIDB. Need msaccess to still use the name schema1_tablex. As you can see, the Oracle table name stays the same, but schema and SID need to be able to be respecified when required.
I need a script, not the linked table manager in the menu.