automatic refresh of access 2003 database

I have a local  access 2003 database on my computer. This data base colects a data from external Oracle
databases on a sale in companiy, trough a pass-trough queries and then trough append queries puts data in tables in local database.
I crated a form for refreshing a database and with clik on a button DB is starting to refresh. What I would like now is to set up a database to refresh it self automaticlly.
During the night because refreshing sometimes tjkes to m┼żuch time and recsources on my computer. So my questionis is there a way to set up my database to refresh automaticlly !
Who is Participating?
als315Connect With a Mentor Commented:
You can use timer event on form for collection data, but I prefer to use windows sheduler for starting Access macro from command line:
Macro can call sub with nesessary actions and can close db after it. You can also compact DB from command line.
You can use the On Timer Event of your Main form to do the automatic refresh. Ju

See the link below:

Patrick MatthewsCommented:
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.