Delete a database object.

      DoCmd.DeleteObject(ObjectType, ObjectName)

   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).


DoCmd.DeleteObject acTable, "T_Patients"

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


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

© Copyright 1999-2015
Some rights reserved