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


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q323659
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).

IN THIS TASK

SUMMARY

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:

http://office.microsoft.com/downloads/2002/extalert.aspx

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

HOW TO TURN OFF THE MESSAGE

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
Modification Type:MinorLast Reviewed:8/9/2004
Keywords:kbdownload kbhowto kbHOWTOmaster KB323659
©2004 Microsoft Corporation. All rights reserved.