Monitoring ACCESS 2000 tables for changes

[Patrick]

Hello!

I am looking for a way to monitor a Temp table in Access 2000. When
the table gets populated, I want a "program/macro/etc" to
automatically get kicked-off and run an UPDATE statement. I am very
new to development and could use some direction on the best way to
accomplish this. Is there a Macro in Access that could take care of
this, or do I need to write some kind of external service (which I
don't know how to even begin to do)?

Thanks!

Patrick

[TC]

Patrick, the best way for a new developer to get help, is to say what you
are trying to achieve from an "business" perspective. That is, describe the
problem - not the solution!

You have actually described a *solution*: "populate temp table, kick off a
process, run an UNDATE statement".

You'll get better help if you describe the *problem*. Given the problem, we
can suggest a solution. But given only a proposed solution, we don't know
what the probem is, so it is fairly tough to comment :-)

HTH
TC
"Patrick" <pg*********@yahoo.com> wrote in message
news:43**************************@posting.google.c om...

Hello!

I am looking for a way to monitor a Temp table in Access 2000. When
the table gets populated, I want a "program/macro/etc" to
automatically get kicked-off and run an UPDATE statement. I am very
new to development and could use some direction on the best way to
accomplish this. Is there a Macro in Access that could take care of
this, or do I need to write some kind of external service (which I
don't know how to even begin to do)?

Thanks!

Patrick