473,320 Members | 1,694 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Can you have access automatically run

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
3 1891
sanniep
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
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
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

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

Similar topics

4
by: Brian Andrus | last post by:
Ok. I upgraded to MS Access 2003 recently and now I am having great heartache. In Access 2002, when I opened a table to view the data, there were wonderful little "plus" signs that I could click...
14
by: dixie | last post by:
What is the best way to implement a front end for an access database via a web browser on a private intranet? This is totally new ground for me. I want to allow users to enter information into...
6
by: Danny Lesandrini | last post by:
I'm using an Access database to drive a web site and the colors of various table backgrounds are stored in Access. I want users of the Access database to be able to select colors for the site, but...
2
by: AA Arens | last post by:
Somebody willing to assist me in the following? I want to have values from one field copied to another field when I choose choose a item from a drop down menu. I have 2 forms: 1 Company...
5
by: adrian.williams2 | last post by:
Hi, I'm having trouble trying to email a report via access... I get a Outlook message stating 'a program is trying to automatically send e-mail on your behalf. Do you want allow this? This...
5
by: Richard Dixson | last post by:
I created a new C# web application. Basically all I am trying to do is create a table that consists of a few rows with two columns in each. And then to set those columns to text values from my...
9
by: JBuckner | last post by:
My macro uses the Send Object (VBA Item.Send) function to email a spreadsheet to an Outlook contact list. I want the function to be completely automatic but Outlook displays a security warning...
10
by: HenHouse | last post by:
Hi folks; Hey wow! First post! Hope it bears fruit... Anyway, I've been teaching myself Access since March by writing an event/contact management database for the firm I work for. It's...
0
by: Arcturus | last post by:
I am new to Access Monster forums. I developed an Access form which employees add their daily route. The form contains a sub-form in data-sheet (tabular) view where users add address and other...
2
by: rlsj | last post by:
I noticed EXCEL can automatically update a list from SharePoint services. Is there a quick and easy way to update a list from an Access query? Is it "better" to create the code in ACCESS...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.