How do you Automate Opening a Database at a Specific Time each week 1

[kbverizon]

I have a database that pulls data from a csv file and conducts some calculations.

The csv file is updated on a Sunday every week. My database is automated to the point where I just have to hit a button and everything else happens for me.

I would like to have the database open automatically and run at a specific time every week.

Is this possible???

Thanks for any help!!!

 

[kjv1611]

I think there is a Windows Scheduler of some sort already in Windows. If you can't use that, there are free programs out there (well, free for personal use at least) that run on timers as well. Or, if you or someone you know, can do some VB-Scripting on your server, I would imagine you could automatically script any app to run whenever you want, based on the system (environ) time.

Stephen
"Jesus saith unto him, I am the way, the truth, and the life:
no man cometh unto the Father, but by me." John 14:6 KJV

 

[jkirkland]

I generally use the Windows Scheduled Tasks to do this.

1. In your DB's AUTOEXEC macro, include the code or macro that you said automates everything from a single button. This way, when the database opens, it automatically runs this code.

2. Go to Windows - System Tools - Scheduled Tasks.

3. After clicking "Next", click "Browse" and find the Access file you want it to open at a specified time.

4. Now tell it when you want Windows to automatically open this access database.

5. It may ask you for you network password.

It will now run at the times you have scheduled for it. Remember to put a "Quit" command at the end of your autoexec macro so that the database closes after it has done whatever it is you set it up to do.

I use this to run reports in the middle of the night and then Access automatically emails those reports to the people specified.

 

[kbverizon]

Perfect!!!

You guys rock!!!!