I have a database with roughly 100 tables in it, now 75ish are linked SharePoint tables, and the other 25 are local access tables. Can I edit my VBA to ONLY scan the local tables and ignore any other tables?
This is my current syntax but it is slow...
This is my current syntax but it is slow...
Code:
Dim tblNamesArray As Variant
tblNamesArray = Array("Table1", "Table2", "Table3", "Table4")
For Each tbl in tblNamesArray
On Error Resume Next
DoCmd.DeleteObject acTable, CStr(tbl)
Next