• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1249
  • Last Modified:

Migrate Microsoft Access database to the cloud

If possible, what is currently the best way to migrate a fairly simple  access database to the cloud?
Database consists of 5 tables, 5 forms and some vba routines.

I prefer a Google Apps integration, but am also open to superior suggestions ...
0
knarf75
Asked:
knarf75
4 Solutions
 
Kelvin SparksCommented:
Have a look at this.

http://www.fmsinc.com/MicrosoftAccess/cloud/link-to-azure-sql-database.html

It uses a SQL database - easy enough to upsize the tables and you're away

Kelvin
0
 
swadhinrayCommented:
What will be your source of DB that you are planing to be in cloud computing.

As only the best way s to visualized your application and data so that end-user don't have to worry or think about the physical location.


0
 
swadhinrayCommented:
Also try to have a look to the cloud computing architect :

http://en.wikipedia.org/wiki/Cloud_computing

I also agree on what  kelvinsparks: said mentioned.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Access 2010 can use and work with Azure. Access 2007 can work directly with Sharepoint. Earlier versions cannot really do this without moving to SQL Server based storage.

Note also that this technology is in it's infancy, so be sure that the current framework will do all that you need before making a decision. Also be sure that you FULLY understand what is happening with this (i.e your data is stored on a remote server somewhere - NOT on your local machines).
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
If you truly want to be in the cloud, you'd use Office 365:

http://office365.microsoft.com/en-US/online-services.aspx

JimD.
0
 
knarf75Author Commented:
Thank you all. I might have further questions but will post a new question later on.
0

Featured Post

2017 Webroot Threat Report

MSPs: Get the facts you need to protect your clients.
The 2017 Webroot Threat Report provides a uniquely insightful global view into the analysis and discoveries made by the Webroot® Threat Intelligence Platform to provide insights on key trends and risks as seen by our users.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now