4 Ways to Get Access Database to Work on an Android Mobile Device

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.Ways To Get Ms Access Database To Work On An Android Mobile Device

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

Use Remote Desktop AppThe 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.

Author Introduction:

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

One Comment

  1. Comment by John Casey:

    I understand the article was focusing on the easiest ways, but my favorite way has been to write a web portal with HTML/ASP/Java Script/VB Script that emulates as much of the original MS-Access database application functionality as possible.

Leave a Reply

Your email address will not be published. Required fields are marked *