B4A Library Jackcess library - uses MS Access database files

rboeck

Well-Known Member
Licensed 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
 

Erel

Administrator
Staff member
Licensed User
Thank you Andrew. I know that many developers have waited for this feature.
 

aaronk

Well-Known Member
Licensed 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
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
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

Administrator
Staff member
Licensed User
Have you copied commons-lang-2.6.jar from the zip file to the libraries folder?
 

metzeller_2013

Member
Licensed 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
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
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
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

Administrator
Staff member
Licensed User
Have you copied the three jar files to the libraries folder?
 

bsnqt

Active Member
Licensed 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
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:
 

Erel

Administrator
Staff member
Licensed User
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).
 
Top