Repeating the same procedure over fixed time interval 2

[DHSBW]

My Access database is divided into a front end with all the forms and backend with all the underlying tables. How can I get the backend database to perform a repetitive function, in this case, search for the existence of a specific table every 30 seconds, and if it exists, insert the data into an archive table. Thanks for the help in advance.

 

[dinger2121]

you can try adding a timer control to a form in your front end that calls a function in your backend. The only question I would have is how to ensure that it will be called if the form is closed. You will have to do some testing.

 

[DHSBW]

Thanks for the reply. Do you have an example of how I would run an insert statement in the backend database from a front end form? I have absolutely no experience in this. I always thought that this was not possible.

 

[dhookom]

Forms have an On Timer event that can contain code the runs at an interval set in the Timer Interval property. You can open the form hidden and let it run in the background. You should not have this form open when developing or writing code in a module.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]