Delete a record

Microsoft Office Access 2003

  1. Open a datasheet, or open a form in Form view.
  2. Click the record you want to delete.
  3. Click Delete Record Button image on the toolbar.

Note  When you delete data, you might want to delete related data in other tables. For example, if you delete a supplier, you probably want to delete the products that the supplier supplies. In some cases, you can make sure the proper data is deleted by enforcing referential integrity and turning on cascade deletions.

ShowDelete a record in a data access page

Important  Once you delete a record, you cannot undo the deletion from the database.

  • On the record navigation toolbar, click Delete Button image.

Note  If you don't see the Delete button, it means one of the following:

  • The page does not support deletions.
  • The designer of the page has customized the button. Look for custom instructions on how to use the page, or contact the designer.