how do i create a trigger in access MDB?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to have a trigger whenever a table is added to (a new row). Is
there a way to do this in an access (MDB) database.
 
Hi.
Is
there a way to do this in an access (MDB) database.
Click to expand...

No. Jet 4.0 doesn't support triggers. However, one may create a query
based upon the table, then bind a form to that query, and in the form's
AfterInsert( ) event, place the VBA code to do what this trigger would have
done.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Triggers in Access 2
Adding a folder results in error in currently working database 4
mdb format and Access 2007 3
is it possible to use triggers in a access database 3
Access 97 Trigger 0
Permissions / Closing MDB left open 1
Change how a slide is triggered 0
Split .mdb back-end 4

Back
Top