I want to execute one make table query which has to put the data into MS Access table from linked MS SQL Server database based on group by clause, every five - ten minutes.
I have huge MS SQL Server database, I linked it to MS Access database (one linked table). I made another table in MS Access which would be the destination table for mentioned make table query. The make table query should be executed against MS SQL Server database every 5 - 10 minutes.
Already have everything but the timing mechanism. I do not think it can be achieved using macros. Only Visual Basic.