What's the best way for a Startup Company to get an application running On the Cloud?

[AndyWCT]

Hi,

Have developed an application for a vertical market, it works well.

Access 2010. As usual the Frontend contains the frms, qrys, rpts, mcrs and VBA modules linked to a Backend that contains the Tables.

You can see a rudimentary screen capture at:


http://www.youtube.com/watch?v=KfgH8y0vKyI

Talked with a company that is willing to consider it BUT won't even look at it until the application is "On the Cloud".

Know what "On the Cloud" means and how to get it there. Have read about SharePoint and Office 360 and a few others; not sure what is the better way to go for a Startup Company.

So here is the scenario:

A user has to be able to log in from any PC and access only his or her data.

All of the events will run on the internet.

The reports will be generated in PDF format.

And here is the question:

What is the better way for a Startup Company to go to get an application running "On the Cloud"?

Would someone be so kind and point me in the right direction?

Thank You for taking the time to read this post.

Andy

[eki einstein]

Office 365 are great but i think its more expensive because it using per-user license(startform $6.99/User) and offcourse you need to change the VBA method to Macro, I have tried Office 365 its run only macro no module & VBA will works, if you want to use your app whit VBA the more rasional Option is MS acces Front end and MsSql Back end in VPS windows , rent a (in my country Indonesia its about $15-$50/month) VPS Hosting(Windows)+Static IP, install MSSQL server express and Upzipping your Ms acceess database to it, but its need to distribute the front end database (form,etc) to each computer(anywhere that have internet connection) that will run the app...

[ssanfu]

Welcome to the forum.

What is the better way for a Startup Company to go to get an application running "On the Cloud"?

First, I have say I have not used Sharepoint. But from what I understand, VBA cannot be used with Sharepoint... so Macros must be used. Amd I don't use macros, only VBA.

We moved our computing "To the Cloud". So in out Cloudspace, everyone has their own VM (Win 7) and we have a "Server". Permissions are set so that each person's VM is private, but they have access to portions of the server. (Not everyone needs to open Quickbooks).

In some ways this is great.... I can connect to the cloud from my work computer, my home computer or my laptop using RDP. If I go somewhere without my laptop, I can open a browser, type in the portal URL and be at my "Office"..... anywhere in the world that has a broadband connection.

But the VM (our VMs at least) is/are slower than our "real" (physical) computer(s).

1) A user has to be able to log in from any PC and access only his or her data.

2) All of the events will run on the internet.

3) The reports will be generated in PDF format.

Point 1 - So the "Cloud" wins over Sharepoint
Point 2 - You need the internet to get to the cloud...
Point 3 - That is part of your application. Or there is a PDF printer installed (something like PrimoPDF)


As far as installing your application "In the Cloud", it is the same as your physical computer.
Each user gets their own copy of the FE.
The FE must be linked to the BE.
The everyone must have R/W permissions to connect to the BE.
And don't forget about setting up "Trusted Locations". (Not sure how to do this with run time version)

If you can set up your app on a real computer, you can set it up in the cloud.

If the client doesn't have Access installed, you could create a run time version. Plus, creating a run time version will help keep unwanted people from mucking up your code/forms/reports/code. (Make sure you have a backup of the most current version of your FE)