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

Colin Evans

Active Member
Licensed User
Longtime User
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

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

Colin Evans

Active Member
Licensed User
Longtime User
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?)
 
Upvote 0
Top