You are currently offline, waiting for your internet to reconnect

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

This article was previously published under Q323659
This article has been archived. It is offered "as is" and will no longer be updated.
Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).


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.

back to the top


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.

back to the top
inf turn off avoid keep from appearing do away with displaying disable permanently

Article ID: 323659 - Last Review: 10/26/2013 17:13:14 - Revision: 4.0

Microsoft Access 2002 Standard Edition

  • kbnosurvey kbarchive kbdownload kbhowto kbhowtomaster KB323659