Change location of ODBC Oracle Table

[Guest]

I want to change the location of some ODBC tables at will.

All the connections information is the same except for the server name.
Passwords, Username, all else is the same.

When I do this manually I use the Linked Table manager, select the tables,
check prompt for new location, then just pick out the new data source, put in
my name and password, then wala!, I'm done. Very simple, but can't seem to
work this out in VBA.

I've tried using the transferdatabase method, but I can't ever get the
connection string just right and the few examples I have found never seem to
cover all the bases.

Any help would be appreciated, even or especially a link to a detailed web
page.

Thanks,

Paul

 

[Douglas J. Steele]

See whether http://www.mvps.org/access/tables/tbl0010.htm at "The Access
Web" helps.

You could also try going DSN-less. I show one way (albeit going against SQL
Server) at http://www.accessmvp.com/DJSteele/DSNLessLinks.html