[AccessD] From Access to Hosted site???

Larry,

The functionality is currently in Access.  If I can go this route and leave it in access...I probably will.  I am curious as to what other approaches listers would suggest.

Thanks for the advice.

Mark


> From: lmrazek at lcm-res.com
> To: accessd at databaseadvisors.com
> Date: Tue, 13 Nov 2007 11:50:42 -0600
> Subject: Re: [AccessD] From Access to Hosted site???
>
> Hi Mark:
>
> If you're looking at running this on a hosted site, then you'll probably
> require a provider that offers a virtual private server or a dedicated
> server. Prices (and service) varies widely, but if you need to actually
> install and schedule an access app, this is the way you'll probably need to
> go.
>
> Larry Mrazek
> LCM Research, Inc.
> www.lcm-res.com
> lmrazek at lcm-res.com
> ph. 314-432-5886
> mobile: 314-496-1645
>
> -----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_hotmailn
> ews
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

_________________________________________________________________
Windows Live Hotmail and Microsoft Office Outlook – together at last.  Get it now.
http://office.microsoft.com/en-us/outlook/HA102225181033.aspx?pid=CL100626971033