Freedom Computers

ACCESS

Delete a table using VBA

It's a very good idea when running MakeTable queries to quietly handle the event of the table already existing:

Sub DeleteIt(tblname As String)
On Error GoTo noTable
CurrentDb.TableDefs.Delete (tblname)
Exit Sub

NoTable:
Resume Next

End Sub