code to dynamically change the Database Name of Linked tables

[Brent_Fangy]

I need to know if any code exist that will allow me to
change the Database name used in the Connect string of a
linked table.

We have 10 companies, all using the same ERP software
package all with their data housed in Oracle (all with the
exact same tables).

I want to be able to switch from database to database for
a user who is logged on in Access, without having to
manually go to the linked table manager.

Any help is greatly appreciated.

Brent Fanguy
IT-Project Manager
(e-mail address removed)

 

[Tim Ferguson]

I want to be able to switch from database to database for
a user who is logged on in Access, without having to
manually go to the linked table manager.
[snip...]

I need to know if any code exist that will allow me to
change the Database name used in the Connect string of a
linked table.

Have you looked up help for the Connect property: that gives you all you
need to know? You can use it for Provider (eg. oracle, sql server, etc) and
security (password, userid) and so on. Don't forget the RefreshLink method
too.

Hope that helps


Tim F

 

[Albert D. Kallal]

What you are looking for can be found here:

http://members.rogers.com/douglas.j.steele/DSNLessLinks.html