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:

[u]Table_A</u>
Field1 = Order Number
Field2 = Status field (when Updated to ‘C’)

[u]Table_B</u>
Field1 = Order Number
Field2 = Line Number

Thanks in advance,


Neal

A Northern Soul

__________________
Neal

A Northern Soul

Access (Jet) tables don't support Triggers.

Bob

To sort of emulate the trigger-like behavior you're after with Jet, you'd need to control the update programmatically: open an ADO recorset based on your tables, update the recordset in code, then persist the recordset in XML format using something like:

rst.Save "C:\SomeDocument.xml", adPersistXML

Bob