Use Microsoft Access files in Android application

Is there any way to use a Microsoft Access files in an Android appli开发者_如何转开发cation?

---

I do not believe there is any way to use a MS Access database with an Android application. Instead, you should probably consider using another database such as SQLite.

You could migrate your Access database to SQLite:

1. Export your Access database into text files, semicolon or comma delimited.
2. Open the SQLite database browser and chose File -> Import -> Table from csv file.
3. Browse for your text file and choose the appropriate delimiter. Click create.

---

If import isn't an option you can make a (PHP) webservice that queries the database. Then call upon that webservice in your android application.

This week i'll be starting a tutorial serie on http://p-xr.com that will explain just that.

---

You can use jackcess, is pretty easy to use, but you can't execute queries.

http://jackcess.sourceforge.net/faq.html

---

Well, if you are using Access 2010, then you can build web sites, and the results are massively scalable to the web in terms of simultaneous users. The so called Access web services are also coming to office 365. So with office 365 (still in testing) or with SharePoint 2010 you can thus publish Access forms to the web. Here is a video of mine, and note how the same Access application at the half way point is run in an standard browser.

http://www.youtube.com/watch?v=AU4mH0jPntI

Note that no ActiveX or Silverlight is required (so it standard web compliant). I have tested the Access applications running on my windows 7 phone and the Access web application also runs well on my iPad (safari browser).

So, I do not see why the Access application would not work and run fine on an android phone. Note that when you publish the Access forms they are turned into xaml (.net zammel forms), and code you write in the Access form is converted into JavaScript. Reports are converted into sql server reporting services.

---

Use a windows machine and access access over a remote control tool. For a bigger scenario, you can use Windows Terminal Services.