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:
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:
On the Tools menu, click Options.
In the Options dialog box, click the Edit/Find tab.
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.