I develop MS Access progams for single workstations. I would like to migrate the table for some of my projects to Cloud so that they may be accessed from different laptops. How do I go about migrating the tables to Cloud?
First migrate your application to something other than the cloud. IE., migrate to SQL first. The steps from SQL to "the cloud" are simpler. You will find yourself making structural changes to the applications. Access has the tendency to "pull everything local" to perform its queries. Rewriting things to run under SQL will get you used to letting a server do your work.
My major recommendation: Given the poor performance of Access, under load, why tempt fate with a cloud based solution?
Um, are you merely interested in allowing multiple clients to make changes to the same data? This would mean you'd want to centralize the access database on some server (or network share) and have your programs connect to it instead of a local instance.
Here's how to do it in a few simple steps:
Burn a copy of your access database to a CD. Use a DVD-ROM if it's really big.
Put CD in a blender or food processor grinding it until the CD is in small dust-like particles.
Outside, scooping a handful at a time, blow gently on the particles in an upward direction.
It may take a day or two for the partials to seed but your Access database will be in the cloud before you know it.
Keep in mind that this is only migrating the data. Access remains the front end and business logic. However, I think that something like SQL Azure is probably cost prohibitive. A better bet would probably be to host your own SQL Server and use the upsize wizard.
@MasterPie: Oh snap! What was I thinking?!?!? Clarification: Unless you live in the Netherlands (or wherever Maddus lives) please follow the blog posts.
Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.