Hi all,
I have 12 linked tables that connect to 4 different databases (3 table to each database). I have to use two different drives (Microsoft ODBC For Oracle and Oracle ODBC Driver).
My problem is that everytime I open Access, I have to relink the tables and imput my password. The biggest hassle is the Microsoft ODBC For Oracle driver tables force me to select the location for each of the tables (a total of 6 times). What's the easiest way to get Access to automatically re-link all the tables so I don't have to spend a couple of minutes everytime I open the program re-linking the tables. Thanks and any help would be appreciated.

Why do you have to "re-link" every time you open the Access database? ... Do you mean "Logon" to the server"? ... Or do you have code to drop and recreate the linked tabledefs? ... The reason I ask is, when you create you're linked TableDef in the Access database, the link info SHOULD be stored in that link ... BY DEFAULT, however, the Server Password is NOT saved ... SOME databases DO NOT ALLOW password "saving" ...

The solutions I have for your is to RE-Create youre links WITH saving the password ... and a link to go to that MAY provide you with more information ...

DELETE all your linked table defs .. then RE-Create then with File > Get External Data > Link tables ... then choose Files Of Type ODBC databases ... I ADVISE to create a DSN that DOES NOT USE A "TRUSTED CONNECTION" ... Eventually you will get to a dialog box the lists the tables in you datasource for you to select, on that dialog, there is a small check box on the lower right that says "Save Password" ... check that box! ... Then when you click ok ... all your tables will be linked with the password "saved" in the "Connect" string property of the newly created linked tabledef.... IF the host of the datasource allows it!

Here is a link for your reading enjoyment ... Be sure and read the initial thread too ... The initial thread deals with SQL Server, but you may gain some insight into some security stuff ...

Oracle Back End

HTH ... (hope that helps!)