Can any body Help me !!! Creating Triggers in VB 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
:-)

AFAIK triggers are a SQLServer "thing" only.
thus, you need a client that can communicate to SQL Server. I suggest you use ISQL/w or Enterprise manager that comes with SQL server 6 and above.
To create a trigger:
CREATE TRIGGER mytrigger on yourtablename
FOR INSERT, UPDATE
AS
...write your SQLCode here

Thanks for the response.

I saw in MSDN library which talks about creating triggers in VB 6 for the Access database, they have shown the e.g. of NWIND.mdb. But the MSDN doesn't tell me where exactly I have to code this trigger. MSDN says you have to open Data View WIndow
Database
Tables
Right click on the table you want to create a trigger but I didn't see any option available for me to create a trigger.


Can anybody help me!!! The company where I am working presently is using MS-Access 8.0 as back-end amd VB6 as front-end. I can't use SQL server 6.0. I know that triggers can be implemented easily in SQL server 6 and oracle. But I am not aware how to implement triggers. I need the following feature :

Whenever a user tries to update TABLE A, a record should be inserted in TABLE B
which will tell me 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,
Sri

Triggers are not available in Access. You may be able to emulate triggers partially by using cascading updates/deletes. The rest has to be done inside your program with code and transactions.

I think you can create a sub/function that writes records in table B, you can call this sub/function passing records changed everytime you code the update.
I tried this to create a log file in access database, every operation calls a function that saves in a table the operation done. I'm sorry but i cant' write code now.


private sub updatebutton_click()
.
.
.
' here the code to update
.
.
trigger (records_changed)
end sub
.
.
.
.
public sub trigger(records_changed as ....)
.
.
.
'here the code to write data in table B
.
.
.

end sub

How will we know which field has been modified before updating? Is there any good solution for my problem. Can anybody put me in the right direction? I appreciate you people are trying to help. Give me example please!!!!!

Thanks,
Sri

You can put a string equal to"" at beginning and everytime a textbox associated to a field changes it can set the string to a value, a.e.:


private sub text1_change()
'here you can also add code to test if already
'changed, something like the function instr to
'serach if mystring has 1

mystring = mystring & "1"

'it says the first field was changed so need
'to be updated
end sub




In the update button you search in mystring what fields are changed.

I will try it out.

Thanks,
Gibli

Thank you guy Lonely Wolf :) U have been very helpful.

- Gibli