HOW TO: Turn Off the "Do You Want to Delete the <Object>" Message in Access 2002

Article translations Article translations
Article ID: 323659 - View products that this article applies to.
This article was previously published under Q323659
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

On This Page


A database object is a table, a query, a form, a report, a macro, or a module. When you try to delete an object, you receive a message similar to the following
Do you want to delete the <Object Type> '<Object Name>'?
where <Object Type> refers to the type of database object, and <Object Name> refers to the name of the object that you are trying to delete.

If you click Yes, the object is deleted. If you click No, the object is not deleted.

NOTE: Microsoft Office XP has built-in functionality that allows you to get more information about difficult-to-troubleshoot alerts or error messages. If you want to turn on this functionality for this and other error messages in Microsoft Office XP, download the "Office XP Add-in: Extended Alerts Button" from the following Microsoft Office Update Web site:
NOTE: If you reached this article by clicking Web Info in an error message, you already have Customizable Alerts turned on.


Microsoft Access displays this message to confirm that indeed you want to delete the object. If you do not want to receive this confirmation message, you can turn it off. To do so, follow these steps:
  1. On the Tools menu, click Options.
  2. In the Options dialog box, click the Edit/Find tab.
  3. Under Confirm, do one or more of the following:
    • To turn off a confirmation message when you change a record, click to clear the Record changes check box.
    • To turn off a confirmation message when you delete a database object, click to clear the Document deletions check box.
    • To turn off a confirmation message when you run an action query, click to clear the Action queries check box. The Action queries check box is not available in an Access project.
NOTE: Microsoft Access always displays a confirmation messsage when you try to delete a data access page. A data access page is not actually stored in the database. The database only has a link to an HTML file that is located outside the database. The Record changes, Document deletion, and Action queries check boxes do not apply to data access pages.


Article ID: 323659 - Last Review: October 26, 2013 - Revision: 4.0
  • Microsoft Access 2002 Standard Edition
kbnosurvey kbarchive kbdownload kbhowto kbhowtomaster KB323659

Give Feedback


Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from