Web Development

Ask something
Discussion Locked

Automating online tasks

0 helpful
2 replies

by jmadrid

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello,

I am working with an online application with an Access database backend and I need to automate some of the processes to run on a daily/weekly basis (or other given times). For example: I need a report run at the end of each week that will gather certain information from the tables in the DB and send the information to me in an e-mail. I want that to run by itself without me having to go in and actual tell it to do it.

As it is now, I have the system configured to run the report assoon as I press the button to tell it to do that and it does it just fine. I dont want to have to tell it to do it though... I need to to be automated and be done by itself.

Can anyone lead me in the right direction of how I might be able to do that?

Here is some more information about my situation:

Server type: Windows
Database type: Access
Page/program language: ASP
Server Access: FTP only (no DLL access, etc)

Any help with this would be greatly appreciated. Thanks!

Jon Madrid

2 replies

by pranav

I have never needed to do this so I am not sure. Since you at this moment have a button that does this, I am assuming that it is calling a macro, or a procedure or something along that lines.
You can use an xml, ini, or text file as a log.
Now whenever your site starts it check if today is the end of week and if the procedure has been run or not based on the log, if it is not then call the procedure.
I know this is not the actual code , but hopefully it will give you some idea.

Pranav

by mstech

Use class module with an automation controller like Excel to access the files via ftp. Script the modifaction of files into reports that Excel sends. This technique works for me to access files on a unix box generated by automation controlled HostAccess 7.0.

This discussion is closed to new replies.