I want to put a password to the BE
I understand I can't simply refresh the links, and need to delete all linked tables from the FE and relink them.
How can I do it using a code? As I'll have to do it every time I deploy a new FE version to the end user.
T'ill now I simply pointed to the new location of the BE and refreshed the links.
I have a code to DROP a table from db.
I also have a table with a list of all tables
I understand I can't simply refresh the links, and need to delete all linked tables from the FE and relink them.
How can I do it using a code? As I'll have to do it every time I deploy a new FE version to the end user.
T'ill now I simply pointed to the new location of the BE and refreshed the links.
Code:
For Each tdf In CurrDB.TableDefs
' If the table has a connect string, it's a linked table.
If Len(tdf.Connect) > 0 Then
tdf.Connect = "MS Access;pwd='" & strDataMDBFilePass & "' ;DATABASE=" & strDataMDBFile & " "
tdf.RefreshLink ' Relink the table.
End If
Next tdf
I have a code to DROP a table from db.
I also have a table with a list of all tables