Android Question jackcess new version

[Hamied Abou Hulaikah]

Dear @agraham
Can you update jackcess library to the latest

Jackcess library - uses MS Access database files

For access to later Access databases you can try this https://www.b4x.com/android/forum/threads/b4a-ucanaccess-demo-works-under-b4j-see-notes.121546/#content The Jackcess library lets you read and update MS Access database files (mdb files). It supports Access versions 200 to 2010. The...

www.b4x.com

Jackcess - Browse Files at SourceForge.net

A pure Java library for reading from and writing to MS Access databases.

sourceforge.net

Thank you

 

[agraham]

I've tried recompiling it for the latest version but it fails. Unfortunately they seem to have changed the database structures in the jar and my existing code is no longer compatible. The changes needed might be small or they might be large, I don't know and I'm afraid that seven years on I don't want to have to relearn something that is no use to me.

If anyone one wants to take a look here is the source and SLC setup ready to compile. You will need to download the Jackcess jar and put it in the libs folder as the archive is too large for the forum if I include it.

 

[Erel]

Have you tried this B4J solution: https://www.b4x.com/android/forum/threads/opening-ms-access-databases-mdb.107963/#content
It might work with JdbcSQL. Worth trying.

 

[Hamied Abou Hulaikah]

I tried this for latest ms access db version and work fine

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