1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| Private Sub btn_LienTable_Click()
Dim chemin As String
Dim BD As DAO.Database
Set BD = CurrentDb
Dim tb As DAO.TableDef
Dim rst As DAO.Recordset
'On ouvre un curseur sur la table
Set rst = CurrentDb.OpenRecordset("SELECT valeur from _SystemMaitre where type = 'CheminBaseData'")
chemin = rst("valeur")
For Each tb In BD.TableDefs
If Left(tb.Name, 4) <> "MSys" Then
If Len(tb.Connect) > 0 Then
DoCmd.RunSQL "DROP TABLE [" & tb.Name & "] ;"
DoCmd.TransferDatabase acLink, "Microsoft Access", chemin & Me.lst_Fichier.Value, acTable, tb.Name, tb.Name, False
End If
End If
Next tb |
Partager