Solved

Automatic Update every 30 days

Posted on 2004-09-20
3
152 Views
Last Modified: 2008-03-03
I have an existing database that I am using to create records.  The user clicks on a button to add records.  This method is dependent on the user to do this every thirty days.  

Can Access automatically run a query every thirty days?  I want the query to autorun whether a user has been in the database or not.   Can Access update the data in a database on its own?

Scott
0
Comment
Question by:Scotto13
3 Comments
 
LVL 41

Accepted Solution

by:
shanesuebsahakarn earned 500 total points
ID: 12106680
It can't do it in itself, but you can use the Windows Task Scheduler to achieve this.

Simply write a macro that runs your query. You can then create a task with a command in this format:

"<path to msaccess.exe>" "<path to your db>" /x yourmacroname

That will run the macro at the times that you schedule.
0
 
LVL 32

Expert Comment

by:jadedata
ID: 12108284
Greetings Scotto13!

  If the query is placed in an mdb built solely to be launched and run your query

  Name a macro that launches the query "autoexec"
  Have the "autoexec" macro launch the query and then shut down the application on a good complete run
  Have Task Scheduler launch/open the mdb on your schedule

regards
:)-j-
0
 

Author Comment

by:Scotto13
ID: 12170384
Thanks shanesuebsahakarn!  This works perfectly.

Scotto13
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

932 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now