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?
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?