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 Button image 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.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!