Thu 15 Feb 2007, 15:16Delegate Kevin said...
Kevin has attended:
Access Introduction course
Auto run query when linked table changes?
I have an append query and a delete query i would like to automatically run each time a linked table updates (linked to excel file).
This will add the data from the linked table to a master table which contains all records and the delete query just deletes null records.
Could you tell me the best way to proceed with this?
In access?
Or can an access query be run from and excel macro?
Many thanks, Kevin.
Tue 20 Feb 2007, 09:51
Edited on Tue 20 Feb 2007, 09:51Trainer Carlos said...
RE: Auto run query when linked table changes?
Kevin
You would need to run both queries from a Macro.
You would also need some VBA code to check if the linked table has updated so as to run the above Query macro.
Carlos
