PC Review


Reply
Thread Tools Rate Thread

code to dynamically change the Database Name of Linked tables

 
 
Brent_Fangy
Guest
Posts: n/a
 
      24th Jun 2004
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 Removed)

 
Reply With Quote
 
 
 
 
Tim Ferguson
Guest
Posts: n/a
 
      24th Jun 2004
"Brent_Fangy" <(E-Mail Removed)> wrote in
news:215b101c45a28$7925d250$(E-Mail Removed):

> 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

 
Reply With Quote
 
Albert D. Kallal
Guest
Posts: n/a
 
      25th Jun 2004
What you are looking for can be found here:

http://members.rogers.com/douglas.j....LessLinks.html


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)
http://www.attcanada.net/~kallal.msn


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change linked tables in replicated database Jonathan Bickett Microsoft Access 1 12th Apr 2007 10:52 PM
Change linked tables in replicated database Jonathan Bickett Microsoft Access 0 12th Apr 2007 06:18 PM
Dynamically create linked tables via C# scott_js Microsoft Access 5 10th Mar 2006 10:16 PM
Code to change all linked tables's Database name Brent_Fanguy Microsoft Access External Data 1 24th Jun 2004 10:11 PM
Dynamically Linking Tables Vs. Static Linked Tables Ernie Microsoft Access External Data 1 6th Jan 2004 07:54 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:58 PM.