[AccessD] From Access to Hosted site???

Joe O'Connell joeo at appoli.com
Tue Nov 13 15:53:03 CST 2007


Mark,

There is no reason why you cannot leave it in Access and utilize a third party hosting service.  In addition to providing email services (both POP and Exchange), my company provides hosting services for many of our clients, including Terminal Services running Access applications.

If you can provide details of your requirements, I will be able to provide a quote for hosting your application.  What version of Access are you using?  What are the bandwidth requirements?  How long does it take to process each zip file?  Is the usage constant throughout the day, or are there peaks and valleys?  How large are the emails?  Do you have a preference for the email system that is used?  Are the emails text only or are they HTML?

Joe O'Connell

-----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 4:27 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] From Access to Hosted site???


So if I ask for advise...and you give it...and I follow...proverbial blind leading the blind???  I have a hammer AND a saw!!!

If I can't leave it in Access...what should I use...and we are not talkng about record count...If I'm lucky...I might have 1000 records in my SQL table and then import(then delete) 3k every 30 minutes.  What 'program' should I use to manage/execute the tasks listed below...every 30 minutes.

Thanks,

Mark


> Date: Tue, 13 Nov 2007 14:43:22 -0600
> From: DWUTKA at marlow.com
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] From Access to Hosted site???
>
> I see (said the blind man, as he picked up the hammer and saw).
>
> Pretty much everything you want to do, you could do with a home setup. (Reliable ISP with a static IP address and domain name, UPS, server OS mirrored drives). I personally don't know of any hosting site out there that let's you host an Access application.
>
> 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 12:12 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] From Access to Hosted site???
>
>
>
>
> Drew,
>
> There are a few reasons:
>
> 1. There will eventually be a front end/UI/webpage for people to subscribe to this service and need to be available.
> 2. Right now I use docmd.sendobject to send the email..fine for a few emails...but I will need to send 1000s (hopefully)...thought it easier to pay for a site with email capability
> 3. I'm trying to get as mobile as possible...don't want to be tied to that single machine...site goes down...hosted =I call someone...Home=I fly home.
>
> Thanks,
>
> Mark A. Matte
>
> P.S...Most of the db's I have created were for very specific tasks...and never had a need to create something on this scale (availability scale)...typically never more than a few users. But my biggest uncertainty is what 'engine' can drive this thing.
>
>
>> Date: Tue, 13 Nov 2007 11:49:53 -0600
>> From: DWUTKA at marlow.com
>> To: accessd at databaseadvisors.com
>> Subject: Re: [AccessD] From Access to Hosted site???
>>
>> 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.
>>
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>
> _________________________________________________________________
> Help yourself to FREE treats served up daily at the Messenger Café. Stop by today.
> http://www.cafemessenger.com/info/info_sweetstuff2.html?ocid=TXT_TAGLM_OctWLtagline
> --
> 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.
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

_________________________________________________________________
Climb to the top of the charts!  Play Star Shuffle:  the word scramble challenge with star power.
http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_oct
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list