table event like on "change" event for worksheet in excel?

[Marv]

I have an asp page that is used to log in information into a table in an
access database. I was wondering if there is an event that can be set up to
get fired once the table is updated so that I can execute some code.

 

[Alex Dybenko]

There is not such event for a table. but if you enter data to this table
using access form - then you can use form's afterupdate event

 

[Marv]

I cannot use access forms to enter the data, that's my limiting factor. Are
you sure there is no such event? What about the event "RecordChangeComplete",
could that be useful? I was going through the list of events and I was
wondering if that can be tailored to my need.

Thanks

 

[Alex Dybenko]

Hi,
this is event of ADO recordset, so if you update your tables via ADO
recordsets - then you can use this event. or, if you update table in ASP
page - then you can just call your procedure "to execute some code"at the
end of you update code in ASP page

 

[Marv]

Hi,
I am grateful for your replies.
But I am not an expert in Access yet and I don't know if what I aim on doing
is achievable so just to clarify the matter. I am updating the table in an
ASP webpage. Once the table is updated, I want a macro to be run in access
(that macro contains methods such as DDEInitiate...) and not a simple stored
sql query procedure and I don't know how to do that. I would really
appreciate it if you can give me more information. An example would be very
helpful.

 

[Alex Dybenko]

Hi,
not sure this is a good idea - to run Access macro from ASP page. I would
make it a following way - once you update your table - you also save the
date/time of update to some field. then you can have an instance of access
running, it checks for this table updates every 5 mins or 1 hour, and if it
see updated records - it run your macro. you can also start Access
application by windows scheduler.