O'Reilly logo

Microsoft® Access® 2010 In Depth by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

20. Emulating Table Triggers with Access Data Macros

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required