Microsoft KB Archive/323659

= HOW TO: Turn Off the &quot;Do You Want to Delete the &quot; Message in Access 2002 =

Article ID: 323659

Article Last Modified on 10/20/2006

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



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
 * HOW TO TURN OFF THE MESSAGE



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  ''?

where  refers to the type of database object, and  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 &quot;Office XP Add-in: Extended Alerts Button&quot; from the following Microsoft Office Update Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=8fbee1d3-c5bb-4a36-a2f7-dc63de2a818c&DisplayLang=en

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:
 * 4) * To turn off a confirmation message when you change a record, click to clear the Record changes check box.
 * 5) * To turn off a confirmation message when you delete a database object, click to clear the Document deletions check box.
 * 6) * 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

Additional query words: inf turn off avoid keep from appearing do away with displaying disable permanently

Keywords: kbdownload kbhowto kbhowtomaster KB323659

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.