Hello,
I wish to update a link to protected table (DB).
I use tdf.Connect = ";DATABASE=" & strNewPath to set the connection
but I do not know how to pass database password parameter.
Can you help me ?
Thank youCode:... For intCount = 0 To dbs.TableDefs.Count - 1 Set tdf = dbs.TableDefs(intCount) If tdf.Connect <> "" Then Me.lblMsg.Caption = "Refreshing " & tdf.Name DoEvents tdf.Connect = ";DATABASE=" & strNewPath tdf.RefreshLink End If ' tdf.Connect <> "" Next intCount ...