[AccessD] From Access to Hosted site???

I would use SQL Server, create a job, and schedule it to run every X minutes.
The question would be if the hosting company would let you email from the
SQL Server.

At 11:50 AM 11/13/2007, you wrote:
>Date: Tue, 13 Nov 2007 17:17:58 +0000
>From: Mark A Matte <markamatte at hotmail.com>
>Subject: [AccessD]  From Access to Hosted site???
>To: Access Developers discussion and problem solving
>         <accessd at databaseadvisors.com>
>Message-ID: <BAY127-W42F5063540A700941CD5BCD2800 at phx.gbl>
>Content-Type: text/plain; charset="iso-8859-1"
>
>
>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
>