[AccessD] Event Flag or Error Flag with Data Change

Darryl Collins darryl at whittleconsulting.com.au
Thu Nov 29 23:21:33 CST 2012


Thanks Stuart,

Good to know there is 'something' there if I ever need it.  I did use triggers in SQL server a lot back in the day and they were awesome.

Cheers
Darryl

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Friday, 30 November 2012 4:10 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Event Flag or Error Flag with Data Change

Yes, same concept - but not nearly as powerful.

The table macros are failry limited in what you can do and the design interface is a POS.

;-{

--
Stuart

On 30 Nov 2012 at 3:44, Darryl Collins wrote:

> From what I understand it is a similar concept to triggers in SQL 
> Server.  But I haven't had the need to play around with that 
> functionality in A2010 my current role so I have zip experience of 
> them.  But it all sounds very promising.
> 
> Cheers
> Darryl
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart 
> McLachlan
> Sent: Friday, 30 November 2012 2:18 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Event Flag or Error Flag with Data Change
> 
> That's the whole point of Access 2010's  Table Macros.
> 
> Any relevant change to the data in the table automagically triggers the defined macro. 
> 
> They have removed the requirement to externally monitor the tables changes. 
> 
> --
> Stuart
> 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list