I have an application which via ODBC will inser a new record into a backend Access 2000 database. This database has no front-end usage. I need to run some additional code which will affect another table in the database on each new insert, however, the inital application (Cognito) is unable to run a macro or code.

Is there anything in access which can act like a trigger of sorts, when a new record is inserted, or do I have to have another application which will check for new records on a timer? Perhaps you have a better suggestion then these 2.

Can anyone help? My VBA knowledge is okayish, not brillant - too used to Delphi. Thanks in advance.