That works thanks with the config file though I cant figure out how to get the path to the Access DB file at the same location as the config.
strFilePath = "jdbc:ucanaccess://" & File.DirApp.Replace("\","/") & "/" & config.Get("db_name") & ";memory=True"
Not sure how to include the ../ in this
Noted re jServer in UI apps, will avoid in the future, but it has been working fine for current use.
I work on conservation projects in many cases without internet and I have set up the UI to give a bit more feedback when running JRDC than just the command window.
We are using phones syncing to an Access database on a laptop over WiFi and It has been working on ships, sub Antarctic bases and field huts with 12v routers.
We just run the server(bat) when we need to sync and then close it again.
Took a while to find a solution that can be used and also changed in the field, so many thanks