<div>
First hit in google:<br />
<br />
<a href="http://www.fabalou.com/Access/Modules/refreshtables.asp" rel="ugc">http://www.fabalou.com/Access/Modules/refreshtables.asp</a>
</div>


First hit in google:

http://www.fabalou.com/Access/Modules/refreshtables.asp [http://www.fabalou.com/Access/Modules/refreshtables.asp]

<div>
the link above looks like it is for msaccess tables. Oracle tables are linked by ODBC, the do not have a path.
</div>


the link above looks like it is for msaccess tables. Oracle tables are linked by ODBC, the do not have a path.

<div>
<a href="http://access.mvps.org/access/tables/tbl0010.htm" rel="ugc">http://access.mvps.org/access/tables/tbl0010.htm</a><br />
<a href="http://support.microsoft.com/kb/159691" rel="ugc nofollow">http://support.microsoft.com/kb/159691</a><br />

</div>


http://access.mvps.org/access/tables/tbl0010.htm [http://access.mvps.org/access/tables/tbl0010.htm]
http://support.microsoft.com/kb/159691 [http://support.microsoft.com/kb/159691]


<div>
I will attempt to work out a solution using parts of the replies.
</div>


I will attempt to work out a solution using parts of the replies.

<div>
<div class="content wysiwyg-content">
I want to use msaccess 2007 linked ODBC Oracle tables with different oracle DBs e.g. dev, uat.<br />
<br />
e.g. original msaccess &nbsp;link is to Oracle table schema1.tablex in SIDA. Access would call this schema1_tablex.<br />
<br />
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.<br />
<br />
I need a script, not the linked table manager in the menu.
</div>
</div>


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.

vba to relink oracle tables in msaccess 2007

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.