Android Question RDC for newbies

[le_toubib]

hi all
i'm totally new to dbs ,
i need to create an app containing forms that fill in parent-child tables that are on a remote db .
i only know ms access .
so i m looking for a simple way to connect (read/write/search records by multiple clients concurrently) to e.g :
www.xxxx.com/yyyy.mdb

MSAccess is my Only choice right now , sadely.
i tried this link :
https://www.b4x.com/android/forum/t...or-and-access-mdb-database.32844/#post-265842

but i actually counldnt know where to start.
is there a step by step tutorial / example as a seed to start from ???

 

[Erel]

You can download the mdb file to the device and then use Jackcess library to access the database.

 

[le_toubib]

Yes but that will b difficult when the mdb file become large , and also when concurrent access is needed , right?
Is it possible to sync the downloaded mdb , with the online one , on exit? I.e merge tables, instead of replacing the whole file ?

 

[Erel]

I don't recommend you use Access with concurrent connections. It will not work. Switch to a real database engine instead.

You can try to use the jdbc driver for MS Access. Start with going over RDC tutorial: Remote Database Connector (RDC) - Connect to any remote DB