Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Trigger + Access ... is it possible?

Author  Topic 

abarsami
Yak Posting Veteran

68 Posts

Posted - 2001-05-01 : 22:08:02
Let's say I have a table that has (company_id, company_name, companyzip)

If I make a trigger that says make companyzip = "1" when I update the company_name field.
I know how to do this in sql and asp. Where I pass company_id in a form and it updates the table where company_id = the id in the form.

If a person used Access to change the companyname. Either the person typed the query or updated the table graphically.

How does the trigger execute??

Can it be done.

How does the trigger know what the company_id is. Thanks
   

- Advertisement -