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

Discussion in 'Android Questions' started by Colin Evans, Aug 4, 2018.

  1. Colin Evans

    Colin Evans Active Member Licensed 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

    Code:
    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?
     
  2. KMatle

    KMatle Expert Licensed User

    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.
     
  3. Colin Evans

    Colin Evans Active Member Licensed 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?)
     
  4. Reviewnow

    Reviewnow Active Member Licensed User

Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice