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

 

[deneus]

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


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

 

[Erel]

I didn't work with this library. However based on the documentation you should set the cursor to the correct row and then call https://www.b4x.com/android/help/jackcess.html#jackcesscursor_setcurrentrowvalue

 

[gmilias]

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

 

[BitsAndBytes]

thats very helpfull . Thank you very much

 

[Erel]

It is better to click on the Like button to show appreciation. It adds less "noise" to the threads and also doesn't move old threads to the top.

 

[ginocasa]

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]

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

Jackcess is for access databases that are different than a dbase III database.

Take a look to the next link probably gonna help you

http://stackoverflow.com/questions/8064937/what-is-the-best-opensource-dbf-driver-for-java

 

[ginocasa]

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]

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]

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]

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

 

[molder26]

Thank you Myron.
yes i was open 97 for read only.
my solution not was very clean, i convert 97 to 2000 and now it's working very well.

http://elguille.info/windows/store/convertir_mdb_access97a2000/instalar.aspx

in this page have a program (.net) to convert 97 to 2000 for windows, only take 2secs and didnt loose any data.

Regards

 

[molder26]

it's possible execute a sql query with jackcess lib?
Thanks

 

[Myr0n]

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

Thank you

 

[Myr0n]

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

 

[gedesgtn]

Please reupload Jackcess1.0.zip
I really need this code
many thanks
link is dead
http://www.b4x.com/android/files/Jackcess.zip
Not found, error 404
The page you are looking for no longer exists. Perhaps you can return back to the site's homepage and see if you can find what you are looking for.

 

[Erel]

Fixed.

 

[Владимир Суворов]

Please, tell me where you can see an example of using the library? In this post and in Jackcess.zip not found. Thanks

 

[Erel]

The documentation is available here: https://www.b4x.com/android/help/jackcess.html

Not sure where you can find an example however there are quite many related threads: https://www.b4x.com/android/forum/pages/results/?query=jackcess