Delete a trigger (ADP)

Note  The information in this topic applies only to a Microsoft Access project (.adp).

When you want to disable the actions defined in the trigger that are automatically carried out on your database immediately following the specified transactions, you can delete a trigger.

You might also want to delete any triggers that enforce referential integrity between related tables if you use database diagrams to design your database. Database diagrams use relationships instead of triggers for this purpose. Thus, if a trigger duplicates a relationship in a database diagram, you should delete either the trigger or the relationship.

1. In the Database window, click Tables under Objects.
2. Right-click the table whose trigger you want to delete and choose Triggers from the shortcut menu.
3. In the Triggers for Table: <table name> dialog box, select the trigger you want to delete from the Trigger Name list, and then click Delete.
4. A message prompts you to confirm the deletion. Choose Yes.