• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 831
  • Last Modified:

create trigger

How can I create a trigger in Access.  I know how to write a trigger in SQL, I just want to know where I go in Access to do this. On the right I see Tables, Queries, etc, but no triggers.  Thanks!

0
ARACK04
Asked:
ARACK04
  • 3
  • 3
  • 2
  • +1
1 Solution
 
peter57rCommented:
Hi ARACK04,

Access does not have triggers.

The closest equivalents are form event procedures.

Pete
0
 
ARACK04Author Commented:
You gotta be kidding me!!!!!
0
 
peter57rCommented:
ARACK04,
My answers to this and your previous question assume that you are talking about Access mdb files.

Pete
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Nope ... Access is not a client/server type db engine, it was designed as a desktop database engine. Triggers and Views are specific to client/server engines. MS doesn't want you using Jet for enterprise type apps (which is where you traditionally see Views and Triggers used); instead, they want you to upsize to the more powerful (and MUCH more expensive) SQL Server ...
0
 
Arthur_WoodCommented:
ARACK04, sounds as though you aren't very familiar with what Access is and what it can and cannot do.  Just to re-iterate what LSMConsulting and pertr57r have already told you, Access does NOT (repeat NOT) have anything like a trigger.  And form event procedures aren't even close, as a substitute.

AW
0
 
ARACK04Author Commented:
Right right.  This is a very small thing I am doing, and so thought Access would suffice.  I am currently looking into either Oracle or SQL Server Express.  Thanks guys.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Oracle ... whew ... TALK about some serious time & cash outlay ... don't get me wrong, you just can't beat Oracle but since this is a "very small thing" I would steer more towards SQL Server Express (believe I supplied a link in your other question, MySQL, etc etc ...
0
 
ARACK04Author Commented:
Oracle was a miserable failure.  Long story, telling it will just make me madder....

SQL Server Express.  I went to the link you gave me, downloaded it, and installed it.  I have looked around and CANNOT FOR THE LIFE OF ME figure out how to create a database, and run queries.  I never thought such a simple goal would be so difficult.  I have used the full blown SQL Server in the past, and am used to Enterprise Manager.  

In my start menu, I have found SQL Computer Manager.  I see nothing in there to create a new database.  I upped the points to 500, because this is starting to make me crazy.  Any help would be MUCH appreciated.   Thanks!

0
 
Arthur_WoodCommented:
check your other question as I posted a link to download FREE MSDE management and query tools, that mimic Enterprise Managfer and Query Analyzer.

the link is:

http://www.msde.biz/msdequery/download.htm (Query Analyzer-like tool)
http://www.msde.biz/msdeadmin/msdeadmin.htm (MSDE Manager tool)

the second one has a $22 cost associated.

AW
0
 
Arthur_WoodCommented:
"MSDE Administration provides a Windows GUI interface for the management of the FREE Microsoft Data Engine (MSDE 1.0/Microsoft SQL Server 7 and MSDE 2000/Microsoft SQL Server 2000).

MSDE Admin is similar to the Microsoft SQL Enterprise Manager, but is at a fraction of the price. Organisations that require a cost effective solution for the management of the Microsoft Database Engine will find that the MSDE Administration provides the functionality they require to manage the MSDE."

from the MSDE Manager tool web page.

AW
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now