Solved

automatic refresh of access 2003 database

Posted on 2011-03-20
4
306 Views
Last Modified: 2013-11-27
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 !
0
Comment
Question by:adisz
4 Comments
 
LVL 40

Accepted Solution

by:
als315 earned 500 total points
ID: 35174459
You can use timer event on form for collection data, but I prefer to use windows sheduler for starting Access macro from command line:
http://support.microsoft.com/kb/209207
Macro can call sub with nesessary actions and can close db after it. You can also compact DB from command line.
0
 
LVL 19

Expert Comment

by:MINDSUPERB
ID: 35174475
You can use the On Timer Event of your Main form to do the automatic refresh. Ju

See the link below:

http://www.blueclaw-db.com/access_event_programming/timer.htm

Sincerely,
Ed
0
 
LVL 92

Expert Comment

by:Patrick Matthews
ID: 35410251
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.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question