ACC: How to Delete Objects Programmatically

• Microsoft Access versions 2.0, 7.0, 97

SUMMARY

Moderate: Requires basic macro, coding, and interoperability skills.

You can delete objects programmatically using either the Delete method or the DeleteObject method. The DeleteObject action can also be used in macros.

MORE INFORMATION

The Delete method applies to the QueryDefs and TableDefs data access collections and can be used to delete queries and tables. The Delete method does not apply to the Containers collection and cannot be used to delete objects such as forms or reports.

You can use the DeleteObject method (in code) or action (in a macro) to delete objects that you cannot delete using the Delete method. Note that Microsoft Access does not request user confirmation when you delete objects using either the Delete method or the DeleteObject method or action.

REFERENCES

For more information about "Delete", search the Help Index for "Delete Method."