link to links?

R

RAYmond RICHard

Hello,

I've an access97 DB (DB1)which links via ODBC to an oracle DB. Now I
whant to create a second access97 DB (DB2) which connects to the links
in DB1. I'd like to do that because I don't whant to create on every
user account the ODBC-link to the oracle DB manualy.

Is there any solution you can imagine?
If yes, please answer ;-)

Best regards
RAY
 
D

Douglas J. Steele

I don't think that will do anything for you.

DB1 is still going to refer to a DSN, and each user is going to need that
DSN. The fact that DB1 is on a server is irrelevant.

DSNs are strictly registry entries. You can distribute a .REG file that
contains the relevant information and have each user add it to their
registry to create the DSN. There's also VBA code available to create DSNs.
http://support.microsoft.com/?id=184608 shows one way (albeit for SQL
Server, not Oracle), and there are other links at the bottom of that page.

However, I find it much simpler to go DSN-less. I show one way to do this at
http://members.rogers.com/douglas.j.steele/DSNLessLinks.html (again, for SQL
Server). Go to Carl Prothman's site (there's a link on my page) and
determine the appropriate connection string to use going against Oracle and
change the code that's currently

tdfCurrent.Connect = "ODBC;DRIVER={sql server};DATABASE=" & _
DatabaseName & ";SERVER=" & ServerName & _
";Trusted_Connection=Yes;"

to set the appropriate Oracle connection string.
 
Top