Open a trigger (ADP)

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

You can open a trigger to view or edit the text of an existing trigger that is stored in your database. Triggers are scripted in Transact-SQL for Microsoft SQL Server databases.

1. In the Database window, click Tables under Objects.

2. Right-click the name of the table whose trigger you want to open and choose Triggers from the shortcut menu.

3. In the Triggers for Table: <table name> dialog box, select the trigger you want to open from the Trigger Name list, and then click Edit.

The trigger is opened in the SQL source code editor which you can use to edit the SQL statements. For more information about triggers and the CREATE TRIGGER SQL statement, see the Microsoft SQL Server documentation.