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:

deneus

Member
Licensed User
Hello, has some example to edit a field in a record?


Hola, tiene algún ejemplo para modificar un campo de un registro?
 

gmilias

Member
Licensed User
Hello,
is it possible via jackcess library to get values from attachment data type fields of an access database table?
Thanks in advance!
 

ginocasa

Member
Licensed User
Hello,
i tried the example and it's working well.I need to read/write a dbase iii file, can jackcess work with him?

Thanks
Gino
 

Myr0n

Active Member
Licensed User

ginocasa

Member
Licensed User
Hi Myron,
thanks for your answer but i think is too hard for me use jdbc driver. I try to download it from mysql but the file is 8M and i didn't understand which file need to copy in the library folder.
Gino
 

Myr0n

Active Member
Licensed User
Hi Myron,
thanks for your answer but i think is too hard for me use jdbc driver. I try to download it from mysql but the file is 8M and i didn't understand which file need to copy in the library folder.
Gino

Hi @ginocasa

I strongly recomend you to start a new thread, explaining your problem and exactly what do you expect to do with your dBase III database.

Just in advance, I recommend you to migrate your dBase database to sqlite or mysql that are free of charge, just if you don't think continue to use it if not to is your case, then to use RDC
 

molder26

Member
Licensed User
Hi, i am having problem with Jackcess and access 97.
Error:

java.io.IOException: jet format 'VERSION_3' does not support writing
at com.healthmarketscience.jackcess.Database.open(Database.java:668)
at com.healthmarketscience.jackcess.Database.open(Database.java:612)
at com.healthmarketscience.jackcess.Database.open(Database.java:582)
at com.healthmarketscience.jackcess.Database.open(Database.java:555)
at com.healthmarketscience.jackcess.Database.open(Database.java:531)
at com.healthmarketscience.jackcess.Database.open(Database.java:509)
at anywheresoftware.b4a.objects.JackcessDatabase.Open(JackcessDatabase.java:170)
at b4a.example.main._btnfactura_click(main.java:522)
at java.lang.reflect.Method.invoke(Native Method)
at java.lang.reflect.Method.invoke(Method.java:372)
at anywheresoftware.b4a.BA.raiseEvent2(BA.java:169)
at anywheresoftware.b4a.BA.raiseEvent2(BA.java:157)
at anywheresoftware.b4a.BA.raiseEvent(BA.java:153)
at anywheresoftware.b4a.objects.ViewWrapper$1.onClick(ViewWrapper.java:78)
at android.view.View.performClick(View.java:5246)
at android.widget.TextView.performClick(TextView.java:10626)
at android.view.View$PerformClick.run(View.java:21256)
at android.os.Handler.handleCallback(Handler.java:739)
at android.os.Handler.dispatchMessage(Handler.java:95)
at android.os.Looper.loop(Looper.java:145)
at android.app.ActivityThread.main(ActivityThread.java:6939)
at java.lang.reflect.Method.invoke(Native Method)
at java.lang.reflect.Method.invoke(Method.java:372)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1404)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1199)

I checked all jar files and xml are in the lib dir and i added a reference
#AdditionalJar: commons-logging-1.1.3

Thanks in advance!
 

Myr0n

Active Member
Licensed User
Jackcess only support from 2000 and 97 readonly.
Check here the requirements


The error that you are having is with the example that is posted in the posting #1?
If not, can you try it please?
If you get any error, can you post it please.
Thanks
 
Last edited:

Myr0n

Active Member
Licensed User
Nice that you found a solution to your problem and came back to share what you did.

Thank you
 
Last edited:

Myr0n

Active Member
Licensed User
it's possible execute a sql query with jackcess lib?
Thanks
As of the 1.1.19 release, Jackcess has the ability to read the Queries saved in an Access database (i.e. interpret the data stored in the system Queries table). However, Jackcess does not have the ability to execute these Queries.

You can read more about it here
 
Top