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!)