Queries in Access

[intrepidtechie]

Is it possible that a query can be set to run each time a table gets updated with new data automatically.
If yes, then what is the method to do this process

 

[johnwm]

If this is a new development then look at MSDE instaed of Access, as MSDE fully supports Triggers.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde/html/msdeforvs.asp

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

http://www.essexsteam.co.uk

for steam enthusiasts

 

[mordja]

Intrepidtechie,

Off the top of my head I dont know how to trigger an event after a table is updated unless it was through a bound form or updated programmatically. How is the table updated ? Without knowing that the only thing I could suggest would be to have a hidden form which had an onTimer event periodically checking the row count of the table.

MOrdja

 

[intrepidtechie]

Hello Mordja,
I am building this MS Access database based application for a local school which gets its main data everyday from an Oracle DB.
The way the Access database gets updated is through to Vb routine.
Simple data transfer code moves data from Oracle to Access. There are some calculation that need to be done after the data gets transfer for which I have some queries setup. Now its run manually and I would like to automate them.
So once the data update is completed in the Access database, immedietatly I want this query to run and complete its job.
This onTimer event sounds interesting. How do you do that.
Any examples if you might have would be great.
Thanks,
IntrepidTechie