Android Question Accessing a SQL Lite database located on a shared windows drive

[Colin Evans]

Hi, could anyone inform me how to connect to a SQL Lite database and read and write records, the database is located on one of my PC's, filename F:\Database\records.db

I can access it using any of my other PC's just linking to the filename and if I utilise the database in my program and use on my device, its fine, i.e. below

Sub Process_Globals
    Public DBFileName As String            : DBFileName = "records.db"
    Public DBFileDir As String                : DBFileDir = File.DirDefaultExternal
    Public DBTableName As String            : DBTableName = "events"
    Public SQL1 As SQL
End Sub

But I want to hold the database on the F: drive and then be able to access, edit , view, add etc from not only my other workstation but also on my phone or tablet.

Is this possible?

 

[KMatle]

I use a B4J app as a server (see asyncstreams). It's very fast and you just need to have a WiFi connection. Here you can have n clients and handle user permissions and e.g. backups.

 

[Colin Evans]

Thanks for taking the time to reply, not sure if this is what I need to do, as its only me accessing the file but from various devices. Is it possible to access a shared folder and then the specified db file? (and if so how?)

 

[Reviewnow]

Please see this tutorial
https://www.b4x.com/android/forum/threads/rdc-simple-way-to-create-your-own-back-end-database.31616/