Moving Your Microsoft Access Database to the Cloud
AccessHosting.Com offers a number of different approaches for moving Access 2007, Access 2010, and Access 2013 databases off of your desktop or corporate network and onto the web. Moving your Access database to the cloud has wide ranging benefits including increased security, high availability and support for multiple users and devices. This page will describe the pros and cons of each approach and present a series of features to consider based on the individual requirements of your application.
Solution #1: Running Access 2007, 2010, or 2013 applications in a Remote Desktop.
Pros: By far the easiest and fastest way to get your mdb or accdb database into the cloud. Extensive device support via Remote Desktop clients for iPad, Kindle Fire, Google ChromeOS and Mac OSX. No need to modify existing applications or convert databases – this is always the quickest way to get up and running. Multiple users supported with secure logon and common drive configuration for Front End/Back End deployment. Backup files to any cloud based storage service. Secure logon with self-service password management. Some support for Access 2003 (Office XP) applications (use the free trial or contact us to determine compatibility). Support for local/remote copy/paste and printing to local devices included.
Cons: Users must acquire and/or install Remote Desktop client (included in Windows, free download for the Mac and around $10 to purchase Jump Desktop for iOS or Android devices).
Solution #2: Running Access 2007, 2010, or 2013 against hosted SQL Server 2012
Pros: Best Scalability and Performance with the power of SQL 2012. Secure logon and SQL Server Management Studio (SSMS) supported. Multiple backup options available. Upload large amounts of data. Can be combined with hosted remote desktop solutions to provide gigabit connectivity between the Access front end and SQL back end.
Cons: Cannot sync application changes automatically to front end clients. ACCDB or MDB files must be converted to SQL compatible format. Lacking in Mobile and Browser based client support (can be alleviated with Remote Desktop Hosting).
Solution #3: Running MS Access against Access Services in SharePoint
Pros: Available with Office 365. Works in most Browsers.
Cons: Requires significant conversion effort to get the data, forms, reports, queries, and macros realigned on the new web paradigm. Requires SharePoint Enterprise license for each user if not using Office 365.