20. Emulating Table Triggers with Access Data Macros
Data macros are a new feature of Access 2010 that lets you extend the range of containers for embedded macros from forms and reports only to include Access tables. Data macros respond to events generated by Data Manipulation Language (DML) instructions, such as Access SQL INSERT, DELETE and UPDATE commands. In this respect, data macros are similar to SQL Server triggers, which are a special type of stored procedure. The first part of this chapter describes where to use and how to create event-driven data macros.
Unlike Access forms and reports, tables don’t have event properties whose values ...
Get Microsoft® Access® 2010 In Depth now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
