Does MS Access have Triggers?
May 17, 2006 12:20 PM   Subscribe

I'm using Microsoft Access 2003, SP2. Does it come with triggers and procedures? I searched Help, and it says trigger is only available to Access project. What's Access project? Help please.
posted by dy to Computers & Internet (6 answers total)
I think an Access Project file (.adp) involves connecting to an instance of Microsoft SQL Server, so presumably the triggers are part of SQL server not Access.
posted by matthewr at 12:29 PM on May 17, 2006

Are you trying to avoid VBA code and macro's ? If so, you may want to consider the idea of a SQL server back end.

Otherwise, I think you are stuck with using VBA code/macro/forms to sort-of simulate a trigger. You can't have something that will execute everytime a certain table is updated... but you can have the code on a form, and have it execute every time that table is updated through your form using whatever appropriate events.

What are you trying to do exactly?
posted by utsutsu at 12:37 PM on May 17, 2006

hi utsutsu, I'm trying to write a trigger to update column X with computation everytime I insert a new record. I guess I can't do that with Access alone, like what matthewr said. thank you guys.
posted by dy at 12:55 PM on May 17, 2006

If you want field X to change everytine you add a record, you have two options. First, this sounds like the kind of thing that can or should be done with a query post hoc. Alternatively, if you absolutely have to change your table values, you can create a form in Access to handle your data entry and use a macro and VBA code to do just about anything to your table(s) in response to the user's actions.
posted by Tallguy at 1:22 PM on May 17, 2006

Don't consider Access, if you want to make a real database. It is that simple.
posted by KimG at 4:24 PM on May 17, 2006

to add just a bit: SQL Server 2000 and 2005 come in freely downloadable versions (for 2000 it's called Desktop Edition, and 2005 has Express Edition). both of these can be accessed from Access and Excel (if need be) and support triggers and views and all that neat stuff. there are (obviously) some limitations to what both of those can do, but if you're trying to stick with Access anyway my bet is you won't hit 'em. (and if you do you can move up to a for-pay copy of the product.)
posted by mrg at 6:29 PM on May 17, 2006

« Older Surely someone must have invented this.....   |   VB? WTF? :( Newer »
This thread is closed to new comments.