Drew Wutka
DWUTKA at Marlow.com
Tue Nov 13 11:49:53 CST 2007
Just curious, why don't you want this running from your house? Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte Sent: Tuesday, November 13, 2007 11:18 AM To: Access Developers discussion and problem solving Subject: [AccessD] From Access to Hosted site??? Hello All, I have asked questions related to this topic before...and honestly, without this list I would have never got this thing to work as is...but now its time to expand. Currently, everything listed below is done in access on a machine at my house. I want to have it hosted somewhere. Here is what it does. 1. check for file on FTP every 5 minutes 2. gets ftp file 3. unzips file 4. imports file LOOP HERE 5. runs SQL against import 6. concantenates results of sql into string 7. emails string END LOOP Lets say the loop part happens about 1000 times with different SQLs and emails that are constantly changing.(SQL and email addresses are stored in a table) At this point lets pretend that there is not a user interface...I just need to replicate the above automated functionality on a hosted site (just not my house...and somewhere reliable). If I could just drop my Access db out somewhere and let it run...I would...or can I? I'm really lost at this point. I guess my question is..."To put this out on a server...what would be the 'engine' or driving force that would coordinate and execute these tasks?" I'm a quick study...and will tackle whatever language/db/platform I need to...I'm just having trouble with my game plan. I don't know where to start. Any guidence or suggestions would be greatly appreciated. Thanks Again, Mark A. Matte _________________________________________________________________ Boo! Scare away worms, viruses and so much more! Try Windows Live OneCare! http://onecare.live.com/standard/en-us/purchase/trial.aspx?s_cid=wl_hotmailnews -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI BusinessSensitve material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.