Creating Triggers in Visual Basic 6.0
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
:-)
Re: Creating Triggers in Visual Basic 6.0
Sorry but Access doesn't support trigers because it is file-share database not engine.
[ufo]
Re: Creating Triggers in Visual Basic 6.0
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