-
Trigger/XML
Hi,
1. How can I execute a Trigger on an Access table on an UPDATE (on a specified field), using VBA/SQL?
2. I then need to produce/export a XML document from the table (or tables using a one-to-many relationship), how do I do this?
Note: This has to be performed on the UPDATE.
EXAMPLE:
Table_A
Field1 = Order Number
Field2 = Status field (when Updated to āCā)
Table_B
Field1 = Order Number
Field2 = Line Number
Thanks in advance,
Neal
-
Re: Trigger/XML
Welcome to the Forums.
Access does not support triggers.
If you are updating the record via code like a .Update call then you can just write your XML file out after.