Web Development

If you have a full installation of Access you should get the option to store the connection string when you link the tables, but this is not always available.

Here is a simple reconnection routine for Linked Tables. It allows you to store the connection string in code and reconnect the linked tables on demand. Use a Macro to "RunCode" and browse to this function which should be stored in a Module.Function UpdConnectStr()

Dim Tdef As TableDef

For Each Tdef In CurrentDb.TableDefs
If Tdef.Connect <> "" Then

Tdef.Connect = "ODBC;DSN=<DSN Name.ATABASE=,<Oracle TNS>;UID=<Login name>;PWD=<Password>;"
End If

Next Tdef

End Function

Only the Linked Tbales are affected as only they have connection strings. Just replace the variables ;-)

This question was closed by the author