I'm trying to write an Android app to access a remote (web online) Access '97 .mdb for read/display only. I have d/l the Jackcess library but cannot find any example code to point me in the right direction to get started. Is there any sample code snippets out there?
This library will not help you connect to a remote database.
You can use jRDC2 with an Access jdbc driver (there is one).
Note that Access is a problematic database. I recommend you to use a real database such as SQLite instead.
Sorry to be a pest. What I need to get going is some code examples on how to make the connection to the remote .mdb. I don't seem to be able to locate B4A samples on getting this thing going using Jackcess. I understand your point re SQL db, but all I need to do is display a limited bit of data from the remote .mdb which is maintained/administered by others.
If I understand the process correctly, I would connect to my .mdb with jRDC2 & then use the Jackcess library to access records in the db. Is that correct? If so, my problem is how do I code the jRDC2 connect?
I'm trying to write an Android app to access a remote (web online) Access '97 .mdb for read/display only. I have d/l the Jackcess library but cannot find any example code to point me in the right direction to get started. Is there any sample code snippets out there
Jackcess is a low level library for accessing MS Access files directly. You could do a "drive mapping" to access the file remotely and then use Jackcess to read a MS Access file, but I don't know how stable that would be. Also, unless you find a wrap for the library, you either will have to create your own or use the library via JavaObject and/or Reflection.