Creating Triggers in Visual Basic 6.0

[gibli]

I need to create trigger on a table which should fire when any of the column is modified. I am using Visual Basic 6.0 as IDE and Access 8.0 as my database. MSDN online speaks about creating triggers but I am not aware how and where to create the triggers, I mean code window. Can someone helm me and tell me in detail how do I create triggers in VB using Data View Window or any other way.

Thanks
Gibli
:-)

[ufo]

Sorry but Access doesn't support trigers because it is file-share database not engine.

[ufo]

Here is what I am looking for ..
Whenever a user tries to update TABLE A, a record should be inserted in TABLE B
which will tell me what field in the TABLE A has be changed. How can I implement this functionality using VB6 and Access Database. I would appreciate it if somebody can explain it with an example.

Thanks,
Gibli