Triggering a Macro

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

I have a macro that I need to execute each time a record
is inserted, removed, or updated in an access table.
Records are being inserted and edited through active
server pages meaning I can't rely on an event, control or
event procedure tied to a form or report. Any thoughts?
 
Access doesn't support triggers and therefore in Access natively, we use
Form Events to activate codes/Macros.

In your case, it is obvious not possible since you don't use Access Forms.
You will have to handle this in ASP if possible (and I don't know ASP).
 
After running any SQL statement, he's going to have to include code in his
ASP page to do whatever it was the Macro's supposed to do.

Brian: Realistically, you should only be using the MDB file as a data store.
Ignore the fact that Access has modules, macros, forms, reports, etc.: you
don't really have the ability to use them when you're working outside of
Access. Your only connection to the database is through the Jet engine, and
it doesn't know about any of the Access items I listed above. You could
possibly use Automation, but I'd advise very strongly against it.
 
Back
Top