B4A Library Jackcess library - uses MS Access database files

For access to later Access databases you can try this



The Jackcess library lets you read and update MS Access database files (mdb files). It supports Access versions 200 to 2010.

The library wraps the Jackcess Java library - details and licensing information are in the archive and the xml documentation.

Jackcess1.0.zip
 
Last edited:

rboeck

Well-Known Member
Licensed User
Longtime User
I never thought, that such an integration is possible! Now android is two steps nearer in the existing pc-world and its much easyier, to migrate existing pc databases to sqlite!
Greetings,
Reinhard
 

aaronk

Well-Known Member
Licensed User
Longtime User
Hello,

What if your mdb file is password protected?

Does it allow you to read and update the file if it requires as password to open the mdb ?
 

Beja

Expert
Licensed User
Longtime User
Great! thanks agraham, I never thought this could be possible so I didn't even bother asking about it.

Can't wait to try it.
 

Beja

Expert
Licensed User
Longtime User
Just tried and got this msg:

Convert byte code - optimized dex. Error
A referenced library is missing: commons-lang-2.6

in the code window there is no reference in red color.
 

metzeller_2013

Member
Licensed User
Longtime User
Good Day Sir,
Just a quick question, will this library enable us to manipulate MS Access database directly without converting to Sqlite?
Adding, Deleting, and Editing of Data? TIA :sign0104:
 

padvou

Active Member
Licensed User
Longtime User
Good Day Sir,
Just a quick question, will this library enable us to manipulate MS Access database directly without converting to Sqlite?
Adding, Deleting, and Editing of Data? TIA :sign0104:

I quote the first post:
The Jackcess library lets you read and update MS Access database files (mdb files). It supports Access versions 2000 to 2010.
 

Devendra Godawatta

Member
Licensed User
Longtime User
This is superb but i am getting and error File I/O error it cannot access Northwind.MDB i ran on release and debug mode, it does not work,
Please help
 

bsnqt

Active Member
Licensed User
Longtime User
That's GREAT, thank you so much agraham.
When I run the demo, it says following error:

Parsing code. 0.02
Compiling code. 0.09
Compiling layouts code. 0.00
Generating R file. 0.33
Compiling generated Java code. Error
B4A line: 49
Table.Initialize(Access.GetTable(\
javac 1.7.0_07
src\b4a\jackcessdemo\main.java:287: error: cannot access Table
_table.Initialize(_access.GetTable("Suppliers"));
^
class file for com.healthmarketscience.jackcess.Table not found
1 error
 

bsnqt

Active Member
Licensed User
Longtime User
Hi Erel,

Shame on me, I made stupid mistake. Yes I did copy them, but for some reason I copied only 2 jar files while understanding clearly that I need to copy all 3.
Now it works, many thanks.

Best regards,
 

mariomb

Member
Licensed User
Longtime User
Ciao Erel, scusa se ti scrivo in italiano ma con l'inglese non sono al massimo.
Ho provato questa demo che mi pare molto interessante anche se ancora non mi funziona..
Dopo aver copiato le 3 librerie nella cartella Libraries, lancio la compilazione che non da nessun errore fino a che all'apertura dell'app,
ricevo il seguente errore:"An error has occurred in sub:main_activity_resume (java line:250) java.io.IOException Continue?"
Tu potresti suggerirmi dove sbaglio?
Mille grazie : Oops:
 
Top