L le_toubib Active Member Licensed User Longtime User Sep 10, 2015 #1 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 ???
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 B4X founder Staff member Licensed User Longtime User Sep 10, 2015 #2 You can download the mdb file to the device and then use Jackcess library to access the database. Upvote 0
L le_toubib Active Member Licensed User Longtime User Sep 10, 2015 #3 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 ? Upvote 0
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 B4X founder Staff member Licensed User Longtime User Sep 10, 2015 #4 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 Upvote 0
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
