I need to update an Access database when a file is loaded on a server. I would like to have the FTP that loads the file run a program on the host after a successful load. I don’t think the FTP can not start Windows secession so it needs to be a standalone EXE. The problem is finding a program that will run out side Windows that can update the Access a Database. My second option would be to have the scheduler on the server run a small Access program each day. It would have to run and then shut down after completed as they don’t want continuous programs running on the server. So far I have not been able to get a Access program to run and shut down by itself. It quits to the Access development screen.. At this point I am open to any options. We go live next week.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Automatic updateing tables
- Thread starter Wjburke2
- Start date
- Status
Similar threads
- Locked
- Helpful tip
- Locked
- Question
