Android Question Jackcess or convert to SQLite

JMW

Member
Licensed User
Longtime User
I have a MS Access database.

For data entry in the field, we’ll use Android devices to collect data. The requirement is to have a subset of the Access tables on the device, add data to these tables, and then import the new data back into the Access database.

Would you put the Access database on the device, and use the Jackcess library to update data

or

should I convert to SQLite, and then use the SQLite ODBC driver to import the data back into Access?
 

eurojam

Well-Known Member
Licensed User
Longtime User
we had the same requirements and did it the way SQLite/ODBC/Access, which works for us. we never used Jaccess, so i can not say anything to that.
 
  • Like
Reactions: JMW
Upvote 0
Top