Is it possible to insert triggers in MS Access, as in other databases, such as SQL Server?
Are you using Access 2010? If so, you can use Access 2010 data macro , otherwise you are out of luck.
Access 2010 data macros (similar to triggers)Access Team August 13th.Last week we outlined improvements to the Access 2010 designer macro, parameter support, and IntelliSense. These improvements are based on Access 2007 macros for sandbox macros, built-in macros, TempVars, debugging and error handling support.. / ( SQL). , , , . , :
Access 2010 data macros (similar to triggers)
Access Team August 13th.
Last week we outlined improvements to the Access 2010 designer macro, parameter support, and IntelliSense. These improvements are based on Access 2007 macros for sandbox macros, built-in macros, TempVars, debugging and error handling support.
. / ( SQL). , , , . , :
, / Access VBA - , SQL Server, MySQL, PostgreSQL. , .
, Access VBA Jet SQL. , , , , , . . , VBA script: SELECT table1.A, table1.B, somefunction() from table1.
SELECT table1.A, table1.B, somefunction() from table1
, . , - , .. , / , script VBA .
OnTimer . Access A95.
. MS Access . , . , , , , , VBA. , , .
2007 ?
MS Access MS SQL Server, . VBA .
ms-, sql-, , . - , / . - , ( ), interfact . , ms , , MS Access ( oracle sql - ). .