Android app and website(server) connection

Question

Hi all

I want to create a browser to view as an administration.

My project is about ferry booking using an android phone. The application is connected to the server. The ferry timing and other info are retrieved via server connection. The database is currently in Microsoft Access.

My question is how do I create a browser to view data (e.g view users, delete users, create notification etc etc)? I want to create so called a 'website' that have access to the same database as the android application. Do I use Microsoft Visual Studio? How am I suppose to create a connection to Microsoft Access so that I can edit the database appropriately?

Thank you. I hope to have replies soon.

-Dayne

Answer 1

You're not entirely clear as to where the current application exists, you hint that either the data is inside of an access database, or are you have an existing application written in access.

In most cases a simple solution is to migrate the data out of your access application into a server based system. The database server you choose should likely be one that your web hosting provider supports. So SQL server or MySQL are often two good choices here.

You can continue to use your access application and have linked tables to that backend database server. (a good many web providers allow this). So, that sql server will presumably reside alongside your web server. This setup will allow you to CONTINUE to use your existing Access application without having to rewrite it. You then simply build some web pages in your favorite web development language to display the "dashboard" of informaton you need.

What tools you build the web site with are as varied as how many different kinds of ice cream there are. So, yes, this can be done with visual studio and asp.net pages, or virtually any web development system you choose. About the only requirement here is to ensure that your web hosting provider supports the deveopment tools you choose.

Depending on your current IT infrastructure, keep in mind that Access 2010 is capable of building 100% web based systems. However this ability in access 2010 does require sharepoint enterprise edition.