AccessHosting.Com offers a number of different approaches for moving Access 2003, 2007 and 2010 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 document 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 2010 against hosted Access Services/SharePoint 2010 Enterprise
Pros: Browser based forms/reports. One version of the application automatically syncs changes to all users. Can develop hybrid applications with a mix of web and client functionality. Mobile Device Support via browser. Secure Active Directory logon with self-service password management. Multiple backup options available.
Cons: Limited to performance constraints of SP 2010 lists. Conversion to SharePoint compatible format required for existing databases. Existing client based forms and reports must be rewritten for web support.
Solution #2: Running Access 2003, 2007, or 2010 applications in a Remote Desktop.
Pros: Extensive device support via Remote Desktop clients for iPad, iPhone and Mac OSX. No need to modify existing applications or convert database – 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 (Amazon S3 Recommended). Secure Active Directory logon with self-service password management. Support for Access 2003 applications.
Cons: users must run Remote Desktop client (no browser based application support). Backup must be performed by the Access administrator or inside the application due to locking scenarios.
Solution #3: Running Access 2007 or 2010 against hosted SQL Server 2012
Pros: Best Scalability and Performance with the power of SQL 2012. Secure Active Directory logon with self-service password management. Multiple backup options available. Upload large amounts of data.
Cons: Cannot sync application changes automatically to front end clients. ACCDB or MDB files must be converted to SQL compatible format.