Trigger in MS Access Database?

Question

Hi All I am using MS Access Database in my project. Now I want to use trigger in MS Access database. can we insert triggers in MS access like we do in other databases like SQL Server ?

Vilas Gite · Answer

hi santosh kumar post resolved? --------

Vilas Gite · Answer

If this helps you then accept as  Mark As Answer

Santosh Kumar · Answer

ok Thanks.

Vilas Gite · Answer

Create project.adp in MS Access …. Create table…. Select SQL SERVER from Database Tools Menu…. Upsizing Wizard will open… then go through step by step… ---------------------------------------------------------------------- If this reply solve your post…then  MARK AS ANSWER !

Vilas Gite · Answer

hi Santosh Kumar Triggers are part of SQL Server not of MS Access and it used an instance in MS Access Project file (.adp). Please see for How to connect instance of Trigger in ADP. http://office.microsoft.com/en-us/access-help/open-a-trigger-adp-HP003085417.aspx

Dorababu Meka · Answer

If you are using Access 2010 then the link which i posted was helpful if not you can create

Santosh Kumar · Answer

Ok. Is there any syntax like create trigger in MS Access.

Dorababu Meka · Answer

In Access there is no such thing as a trigger. More info check here http://blogs.office.com/b/microsoft-access/archive/2009/08/13/access-2010-data-macros-similar-to-triggers.aspx