DoCmd.DeleteObject

Delete a database object.

Syntax
      DoCmd.DeleteObject(ObjectType, ObjectName)

Key
   ObjectType  An AcObjectType constant that represents the type
                    of object to copy.

   ObjectName  The name of an object to delete.

Either destinationdatabase or newname (or both) must be specified.

If sourceobjecttype and sourceobjectname arguments are left blank, Access will delete the object selected in the Database window.

To select an object in the Database window, you can use the SelectObject action or SelectObject method with the In Database Window argument set to Yes (True).

Examples

DoCmd.DeleteObject acTable, "T_Patients"

“It devoured my paper, it was a really good paper” ~ Ellen Feiss

Related

CopyObject - Copy an Access database object
Rename - Rename an object.