Check for table and delete it with a Macro

[Sully38]

I do not use Macros all that often I need to search for a table existance and if present delete it using only a macro is this possible?

 

[Norie]

I don't know if you'll be able to do it using a macro.

You could do it using VBA code. Something like this perhaps:

Function IsTable(tblName As String) As Boolean
' returns true if there is a table called tblName

Dim db As Database
Dim tdf As TableDef

Set db = CurrentDb

    For Each tdf In db.TableDefs
        IsTable = (tdf.Name = tblName)
        If IsTable Then Exit Function
    Next
    
End Function

Sub DeleteMyTable()
    
    If IsTable("MyTable") Then
        DoCmd.DeleteObject acTable, "MyTable"
    End If
        
End Sub