Attend XDA's Second Annual Developer Conference, XDA:DevCon 2014!
5,806,408 Members 52,710 Now Online
XDA Developers Android and Mobile Development Forum

Android Access Database

Tip us?
 
kronos82
Old
(Last edited by kronos82; 29th September 2009 at 05:51 PM.)
#1  
Member - OP
Thanks Meter 0
Posts: 49
Join Date: Mar 2008
Location: Chicago
Default Android Access Database

Here we go:
I use a number of Microsoft Access Databases for my work, and each one is intensely coded and designed and basically run like actual programs. What I am looking for is to be able to take these databases with me. Now understanding that Microsoft and Android are two completely different beasts, what I really am looking for is the ability to take the tables (I use all Back-end database so all my tables are in a completely separate file then all my forms, queries, and reports) and the data with me and be able to run them in a program on Android that keeps the relationships and fields and all of that sort of stuff.

Now what would be great is the ability to use forms (even if special forms for android need to be made), run queries, and even be able to run reports and print as PDFs.

now I know how to code in VBA, hence the extensive coding I have done in Access, so anybody willing to WORK WITH in creating an Android Program to basically be an extension of Microsoft Access please contact me. Please not I use the words WORK WITH loosely, while I am trying to learn how to Program for Android, I currently do not have a computer that I can use to develop programs for android on, and well I would be only able to create the "Hello World" starter program and this project seems a slight bit more complicated. But what I can bring to the table is real world experience in testing and using the program day in and day out, a number of already existing Microsoft Access Databases ranging from Complex to Simple that I use every day. Really a program that can run Microsoft Access Tables on Android would be really useful to me and I am willing to do anything to help make this happen.
Kronos82
 
benmyers2941
Old
#2  
benmyers2941's Avatar
Senior Member
Thanks Meter 8
Posts: 363
Join Date: Oct 2007
Location: Phoenix, AZ
Quote:
Originally Posted by kronos82 View Post
Here we go:
I use a number of Microsoft Access Databases for my work, and each one is intensely coded and designed and basically run like actual programs. What I am looking for is to be able to take these databases with me. Now understanding that Microsoft and Android are two completely different beasts, what I really am looking for is the ability to take the tables (I use all Back-end database so all my tables are in a completely separate file then all my forms, queries, and reports) and the data with me and be able to run them in a program on Android that keeps the relationships and fields and all of that sort of stuff.

Now what would be great is the ability to use forms (even if special forms for android need to be made), run queries, and even be able to run reports and print as PDFs.

now I know how to code in VBA, hence the extensive coding I have done in Access, so anybody willing to WORK WITH in creating an Android Program to basically be an extension of Microsoft Access please contact me. Please not I use the words WORK WITH loosely, while I am trying to learn how to Program for Android, I currently do not have a computer that I can use to develop programs for android on, and well I would be only able to create the "Hello World" starter program and this project seems a slight bit more complicated. But what I can bring to the table is real world experience in testing and using the program day in and day out, a number of already existing Microsoft Access Databases ranging from Complex to Simple that I use every day. Really a program that can run Microsoft Access Tables on Android would be really useful to me and I am willing to do anything to help make this happen.
I think we must have the same job

Android utilizes an sqlite database engine and it looks like sqlite already offers a conversion utility HERE. The real question would be how to get the data in and out of the phone. Regarding forms, they definitely would need to be custom built.
 
kronos82
Old
#3  
Member - OP
Thanks Meter 0
Posts: 49
Join Date: Mar 2008
Location: Chicago
Thanks this is deffenetly a start, From what I can tell this This Looks to be the most promising, It looks like all you would have to do is put a MS Access Database file on your SD CARD and have a program access it. That way you copy it back and forth. Unfortunately it doesn't support Access 2003, but I can save down. I also got a lot of learning to do in programing Java programs.

Forms would be as simply as making a program, this is great thanks much
Kronos82
 
dagwud
Old
#4  
Junior Member
Thanks Meter 0
Posts: 25
Join Date: Oct 2009
Quote:
Originally Posted by kronos82 View Post
Here we go:
I use a number of Microsoft Access Databases for my work, and each one is intensely coded and designed and basically run like actual programs. What I am looking for is to be able to take these databases with me....
I would like to say, "yes, please!" to this idea. I currently use Smart List to Go (the descendant of ThinkDB) on my Palm TX. The TX is dying, and I've been shopping for a replacement. HanDBase exists for the iPhone, but I don't want an iPhone. So I've been focused on WinMo - not by choice as much as by necessity.

And android option would be very welcome around my computers.
 
Freedomcaller
Old
#5  
Senior Member
Thanks Meter 2
Posts: 231
Join Date: Jan 2009
Quote:
Originally Posted by benmyers2941 View Post
I think we must have the same job

Android utilizes an sqlite database engine and it looks like sqlite already offers a conversion utility HERE. The real question would be how to get the data in and out of the phone. Regarding forms, they definitely would need to be custom built.
androids sqlite its for applications to access and store data using java code.

try the pocket office app
 
benmyers2941
Old
#6  
benmyers2941's Avatar
Senior Member
Thanks Meter 8
Posts: 363
Join Date: Oct 2007
Location: Phoenix, AZ
Quote:
Originally Posted by Freedomcaller View Post
androids sqlite its for applications to access and store data using java code.

try the pocket office app
Exactly and we're talking about creating an app that would enable manipulation of an sqlite database. Essentially all that would be needed would be to create a ui framework wrapper for the existing api in android. Not the least monumental task I've heard of an individual taking on but not the most either.

The versions of pocket office that I've seen for android do not currently support Access databases as far as I'm aware. If I'm wrong could you post a link and save everyone some trouble?
 
HarrisonBP
Old
(Last edited by HarrisonBP; 14th October 2010 at 07:19 PM.)
#7  
Junior Member
Thanks Meter 0
Posts: 22
Join Date: Jun 2010
Location: Baton Rouge
aaaaaaaaaaaaaaaaaaa
 
mihapi
Old
#8  
Junior Member
Thanks Meter 1
Posts: 3
Join Date: Nov 2010
Quote:
Originally Posted by kronos82 View Post
Thanks this is deffenetly a start, From what I can tell this looks to be the most promising, It looks like all you would have to do is put a MS Access Database file on your SD CARD and have a program access it. That way you copy it back and forth. Unfortunately it doesn't support Access 2003, but I can save down. I also got a lot of learning to do in programing Java programs.
Jackcess library is now patched to support android (will be in 1.2.2 release). Also seems to support 2000, 2003 and 2007 formats now.

Works great for me.
 
zeiv
Old
#9  
Junior Member
Thanks Meter 0
Posts: 21
Join Date: May 2007
View jackcess site. Couldn't find anything on support for android. I'm using htc desire and would really like to find program to view ms access file. Can you tell me how you do it?
Samsung S3 mini

HTC Desire
Android 2.2
 
mihapi
Old
(Last edited by mihapi; 19th November 2010 at 09:10 AM.) Reason: give example
#10  
Junior Member
Thanks Meter 1
Posts: 3
Join Date: Nov 2010
As I remember reading worked as on PC, while writing had some problems.

This forum prevents me from linking directly, but if you click tracker/patches on Jackcess project, check Android Compatibility Fix - ID: 3101578

Quote:
The changes are in trunk and will be in the 1.2.2 release. I've added some
notes which will eventually make it to the FAQ page on the website
detailing the compatibility steps:

- Set the system property "com.healthmarketscience.jackcess.broken
Nio=true"
- Set the system property "com.healthmarketscience.jackcess.resour
cePath=res/raw/"
- Copy the *.txt, *.mdb, and *.accdb files from the
"com/healthmarketscience/jackcess/" directory in the Jackcess jar to the
"/res/raw" Android application directory.
- Before executing any Jackcess code, set the current Thread's context
classloader, e.g.
"Thread.currentThread().setContextClassLoader(Data base.class.getClassLoader())".
Until this version (1.2.2) is released you need to build lib yourself.

You also need commons-lang and commons-logging from apache commons.

Before you use Jackcess in Android code, you set
Quote:
Thread.currentThread().setContextClassLoader(
getClass().getClassLoader());

System.setProperty(
"com.healthmarketscience.jackcess.brokenNio",
"true");
System.setProperty(
"com.healthmarketscience.jackcess.resourcePath ",
"res/raw/");
and copy those resource files to res/raw

Then you can work as on PC, for example open /sdcard/yourprogram/file.mdb

Jackcess has no GUI, it's a library to read/write access files.

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes