>I need to create a trigger in a Ms Access Database.
>I need SQL sintax to creat it with delphi and ADO objects.
>
>Any Idea?
>
AFAIK, Access does not give you the capability to define triggers. In your code that INSERTs, UPDATEs or DELETEs, you have to write your own code and manually fire it before/after these events.
If you want triggers, go to SQL Server, MSDE or VFP.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao