I am trying to relink tables from an remote mdb file that is password protected using ADO. I've tried:
I get the infamous ISAM error on the Link Provider string property.
Does anyone know the correction I need to relink the table of a remote mdb file that is password protected?
Thanks,
Rewdee
Code:
const cOLEDB as string="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
...
...
For Each tbl In cat.Tables
'don't bother relinking tmp objects
If Left$(tbl.name, 1) <> "~" Then
If tbl.Type = "LINK" Then
tbl.Properties("Jet OLEDB:Link Provider String") = cOLEDB & "C:\SomeFile.mdb ;PWD=PssWrd"
tbl.Properties("Jet OLEDB:Link Datasource") = "C:\SomeFile.mdb"
End If
End If
Next
Does anyone know the correction I need to relink the table of a remote mdb file that is password protected?
Thanks,
Rewdee