B4A Library Jackcess library - uses MS Access database files

For access to later Access databases you can try this

B4A UCanAccess Demo (works under B4J - see notes)

This demo is a slight modification of @klaus's B4XPages SQLiteLight2 demo (https://www.b4x.com/android/forum/threads/b4x-b4xpages-b4xpages_sqlitelight2-cross-platform-project.119258/#content). It demonstrates that UCanAccess can work under Android, given one uses the right version of UCanAccess...

www.b4x.com

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

 

[rboeck]

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

 

[Erel]

Thank you Andrew. I know that many developers have waited for this feature.

 

[newSteve]

Really? This is awesome! I can't wait to try it!

 

[aaronk]

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 ?

 

[margret]

Thanks so much for this lib!! This is really GREAT!

 

[Erel]

What if your mdb file is password protected?

It shouldn't matter. See this FAQ: Frequently Asked Questions

 

[Beja]

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]

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.

 

[Erel]

Have you copied commons-lang-2.6.jar from the zip file to the libraries folder?

 

[Beja]

:signOops:

Thanks Erel,

 

[metzeller_2013]

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]

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]

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]

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

 

[Erel]

Have you copied the three jar files to the libraries folder?

 

[bsnqt]

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]

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:

 

[Reviewnow]

Jackcess 2.0 is out any update?

 

[Erel]

It might be updated in the future. For now I don't see any significant new feature in the new version (which is not backwards compatible).