Solved

Migrate Microsoft Access database to the cloud

Posted on 2011-03-14
6
1,147 Views
Last Modified: 2014-11-12
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
Comment
Question by:knarf75
6 Comments
 
LVL 22

Assisted Solution

by:Kelvin Sparks
Kelvin Sparks earned 125 total points
ID: 35126695
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
 
LVL 2

Expert Comment

by:swadhinray
ID: 35126701
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
 
LVL 2

Assisted Solution

by:swadhinray
swadhinray earned 125 total points
ID: 35126707
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
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 125 total points
ID: 35127198
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
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 125 total points
ID: 35127498
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
 
LVL 4

Author Closing Comment

by:knarf75
ID: 35155942
Thank you all. I might have further questions but will post a new question later on.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Healthcare organizations in the United States must adhere to the guidance of both the HIPAA (Health Insurance Portability and Accountability Act) and HITECH (Health Information Technology for Economic and Clinical Health Act) for securing and protec…
Steve Terp was featured in a video created by CRN about how "Channel Is Crucial To Market Disruption". Click on View source to see the video and article
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now