i want to insert data into table1 from table2. System can find update in table2 and insert into table1 after every 5 minutes.
please advised.
i want to insert data into table1 from table2. System can find update in table2 and insert into table1 after every 5 minutes.
please advised.
make an append query , add tbl1 to tbl2.
put this query in a macro , mRunMyQry ,with set warnings = false (so you dont get the questions propmpt.
macro: mRunMyQry =
setWarnings = false
docmd.openquery "qaAddTbl1ToTbl2
in a form set the timer properties:
timer interval = 300000. (1000=1sec, so 300,000=5min)
in the ON TIMER event= mRunMyQry
the FORM must be open to run the macro.
it will then run every 5 min.
2. If your have back-end database, design a special front-end app. Create a VB script, which opens this front-end, runs a update query from there, and then closes the front-end (or leaves it open - then it must check at start, is the front-end open or not). Create windows scheduled task, which in every 5 minutes runs the VB script;
3. Move your back-end to SQL Server. Create a stored procedure, which updates the table. Create a Job in SCL Server, which every 5 minutes executes the procedure (if you have SQL Server Express only, you can't define Jobs and must run the procedure using windows scheduled task).