Migrating your database will involve re-writing all your database tables and objects into a SharePoint compatible format. This can cost a great deal of time and money. Our remote desktop solution is more cost-effective than other migrating technologies, but it also takes no time at all to configure – saving you time and money.
There are many techniques for moving your Microsoft Access database from a local area network environment to the internet cloud. We will use this blog to evaluate the pros and cons of each technique . We will allow you to make informed decisons and select the best tool for the job of converting or hosting your Access Database application.
We have a number of solutions that allow you to run Microsoft® Access™ applications inside a web browser or desktop operating system. Even Mac OS/X and the iPhone or iPad can run Microsoft Access.
Moving Your Microsoft Access Database to the Cloud
AccessHosting.Com offers a number of different approaches for moving Access 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.
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 including offsite replication. Can be upgraded to dedicated environment to meet the requirements of complex applications.
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.
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. Secure Active Directory logon with self-service password management. Support for Access 2003 applications. Can be upgraded to dedicated environment to meet the requirements of complex 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.
Pros: Best scalability and performance with the power of SQL 2012. Secure Active Directory logon with self-service password management. Multiple backup options available including offsite replication. Upload large amounts of data. Can be upgraded to dedicated environment to meet the requirements of complex applications. All transactions and data encrypted on disk and over the wire for compliance with international security standards.
Cons: Cannot sync application changes automatically to front end clients. ACCDB or MDB files must be converted to SQL compatible format.