How to Disable Data Encryption on Nexus 6

In late September, Google decided to step on NSA’s toes and turn on encryption by default in … more

DJI Phantom 2 Vision+ Review – XDA TV

The holidays will be here in no time, so why not start thinking about gifts now? Youll be ahead … more

Mozilla Ditches Google, Makes Yahoo Default Search Engine

Mozilla and Google have had a long-standing relationship of about 10 years. Google … more

Learn More About Linux with Linux Man Pages

Linux is quite a powerful and very configurable operating system. Thanks to some user-friendly … more

Welcome to XDA

Search to go directly to your device's forum

Register an account

Unlock full posting privileges

Ask a question

No registration required
Post Reply

Android Access Database

OP kronos82

29th September 2009, 06:46 PM   |  #1  
OP Member
Flag Chicago
Thanks Meter: 0
 
49 posts
Join Date:Joined: Mar 2008
More
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.
Last edited by kronos82; 29th September 2009 at 06:51 PM.
30th September 2009, 05:19 AM   |  #2  
benmyers2941's Avatar
Senior Member
Flag Phoenix, AZ
Thanks Meter: 8
 
363 posts
Join Date:Joined: Oct 2007
More
Wink
Quote:
Originally Posted by kronos82

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.
30th September 2009, 02:54 PM   |  #3  
OP Member
Flag Chicago
Thanks Meter: 0
 
49 posts
Join Date:Joined: Mar 2008
More
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
20th October 2009, 03:44 AM   |  #4  
Junior Member
Thanks Meter: 0
 
25 posts
Join Date:Joined: Oct 2009
More
Quote:
Originally Posted by kronos82

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.
20th October 2009, 08:45 AM   |  #5  
Senior Member
Thanks Meter: 2
 
231 posts
Join Date:Joined: Jan 2009
Quote:
Originally Posted by benmyers2941

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
21st October 2009, 03:44 AM   |  #6  
benmyers2941's Avatar
Senior Member
Flag Phoenix, AZ
Thanks Meter: 8
 
363 posts
Join Date:Joined: Oct 2007
More
Quote:
Originally Posted by Freedomcaller

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?
14th October 2010, 08:16 PM   |  #7  
Junior Member
Flag Baton Rouge
Thanks Meter: 0
 
22 posts
Join Date:Joined: Jun 2010
More
aaaaaaaaaaaaaaaaaaa
Last edited by HarrisonBP; 14th October 2010 at 08:19 PM.
6th November 2010, 04:11 PM   |  #8  
Junior Member
Thanks Meter: 1
 
3 posts
Join Date:Joined: Nov 2010
Quote:
Originally Posted by kronos82

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.
16th November 2010, 08:59 AM   |  #9  
Junior Member
Thanks Meter: 0
 
21 posts
Join Date:Joined: 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?
19th November 2010, 07:25 AM   |  #10  
Junior Member
Thanks Meter: 1
 
3 posts
Join Date:Joined: 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.
Last edited by mihapi; 19th November 2010 at 10:10 AM. Reason: give example

Post Reply Subscribe to Thread
Previous Thread Next Thread
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes