https://github.com/walter426/VbaUtilities/blob/master/AccessObjUtilities.bas
All .mdb and ODBC link tables will be deleted by below function
'Remove all link tables
Public Function RemoveLink() As String
On Error GoTo Err_RemoveLink
Dim FailedReason As String
Dim tdf As TableDef
For Each tdf In CurrentDb.TableDefs
If tdf.Attributes = dbAttachedTable Or tdf.Attributes = dbAttachedODBC Then
DoCmd.DeleteObject acTable, tdf.Name
End If
Next tdf
Exit_RemoveLink:
RemoveLink = FailedReason
Exit Function
Err_RemoveLink:
FailedReason = Err.Description
Resume Exit_RemoveLink
End Function
沒有留言:
張貼留言