ACC: How to Delete Objects Programmatically (116148)
The information in this article applies to:
- Microsoft Access 2.0
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q116148
Moderate: Requires basic macro, coding, and interoperability skills.
SUMMARY
You can delete objects programmatically by using either the Delete method
or the DeleteObject method. You can also use the DeleteObject action in
macros.
MORE INFORMATION
The Delete method applies to the QueryDefs and TableDefs 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
by using either the Delete method or the DeleteObject method or action.
REFERENCES
For more information about "Delete", search the Help Index for "Delete
Method."
For more information about DeleteObject, search the Help Index for
"DeleteObject Action" or "DeleteObject Method."
| Modification Type: | Major | Last Reviewed: | 5/6/2003 |
|---|
| Keywords: | kbhowto kbProgramming KB116148 |
|---|
|