• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1276
  • 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
Frank
Asked:
Frank
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
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
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)President / OwnerCommented:
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
 
FrankBusiness OwnerAuthor Commented:
Thank you all. I might have further questions but will post a new question later on.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

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