By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,285 Members | 1,636 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,285 IT Pros & Developers. It's quick & easy.

Can you have access automatically run

P: 17
Hi,
When my database opens I have it set up to run a bunch or queries, format, generate, and save output as excel files. Can I set this to run automatically at night? If yes how would I do this?

Thanks

Virginia
Oct 10 '06 #1
Share this Question
Share on Google+
3 Replies


P: 48
Hi,
When my database opens I have it set up to run a bunch or queries, format, generate, and save output as excel files. Can I set this to run automatically at night? If yes how would I do this?

Thanks

Virginia
It depends on the platform the database is running. If the database is on a server you could have the server execute a task which starts your database, on opening the database will execute the functions above. If the database is on a Windows workstation you could use Taskmanager to execute the database, for this the workstation will have to be powered on.

Bottom line; autostarting the database will have to be a task run by the platform (server, workstation) the database is on.

Sander
Oct 11 '06 #2

P: 52
GinnyP

Yes you can do that through the Windows Scheduled Task. I actually have three databases who runs automatically.

Go to - Start - All Programs - Accessories - System Tools - Scheduled Task and select your database.


On the StartUp option of your database, create a form for startup ( you can create any form and even not related to the forms you use in your database ).

On the Open Event of that form, write a DoCmd statement to run the queries you need to run, then put a DoCmd.Quit at the end (to quit the database after running the queries so you want have to worry of seeing your database open on the next morning) on that same Open Event.
Oct 11 '06 #3

P: 4
Can anyone tell me how to execute an access database from a vb program? Our windows scheduler is disabled. The database resides on my local machine.
Nov 7 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.