G Guest Feb 5, 2007 #1 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.
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.
6 '69 Camaro Feb 5, 2007 #2 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.
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.
