In this article, we look at several options through which we can get an MS Access database to work on Android Mobile device
If you are someone who constantly needs to make use of the MS Access application even when you are not in office then this article is a must-read for you. For those of you who are looking for options to make use of Access application on devices other than the official work computers, we are going to provide you with some handy tips to make use of Access on your Android devices. For most of the users their Android mobile is the device that they usually have with them most of the times, so making use of the same for accessing Access is something they have always wanted, but have not been able to implement.
In this article, we give you a few tips and suggestions, which will help you, use Access on your Android mobile device.
Use Remote Desktop App
The Remote Desktop app from Microsoft is one of the options you can try for connecting your office computer to another device. Thus allowing you access to multiple applications on your system. However, this option has a few drawbacks.
- Since this allows you access to all applications on the computer, including the heavy files, it ends up consuming a lot of time and cellular data while opening.
- Access has not been developed as a mobile-friendly app, so viewing records will anyway be a challenge.
Using Database apps
Apart from using the app that remotely connects you to the complete database, you can opt for Access apps for your mobile. There are different apps for Android and IOS, but both do not seem to work as well as the desktop version of the application. They can provide you with very basic features, and not the advanced business logic that is available in the desktop version.
Converting Access Databases
If installing the apps does not work for you, another option can be to convert your desktop friendly databases to android application. Since the databases are not built for running on Android, they will have to be converted first. You might opt for migrating database to SQLite so that the Android apps can make use of it. You will now be able to edit your database. For syncing the data back to Access database, you will have to make use of a script.
Using SharePoint for Web databases
One of the recently launched features of Office 365 can come to your rescue from this trouble. Deploy your Access application by making use of SharePoint, and then access the SharePoint apps. MS Access can easily be managed using a SharePoint site in any of the browsers. Thus giving you the freedom to use Access application over a cloud, and use it through a browser. You can also make use of SharePoint apps, thus allowing you to decide who all should be given the access for managing your apps, and who shouldn’t. This method involves a bit of coding, so if you are opting to go for it, make sure you either have a programming team or can do it yourself.
Irrespective of the improvements seen in MS Access over the years, the application remains uniquely vulnerable to database crashes. Hence all Access users should keep a handy tool that can repair Access databases.
Vivian Stevens is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including sql recovery and excel recovery software products. For more information visit www.datanumen.com