By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,222 Members | 1,123 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,222 IT Pros & Developers. It's quick & easy.

Monitoring ACCESS 2000 tables for changes

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.