SQLite in win10 access from Android (1 Viewer)

FuzMic

DataBase Tinker
Local time
Today, 12:06
Joined
Sep 13, 2006
Messages
706
Hi gurus

Let's say I create a database in win 10 PC using SQLite. I believe with the right ODBC driver I can have a front end build with msAccess to use this backend.

My project is to use Rad studio xe5 to develop a front end in an Android device. I am now trying to figure out how the android connect to the Win PC SQLite backend database through the wifi. Pardon the clumsy way to break this missing knowledge
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 05:06
Joined
Jul 9, 2003
Messages
14,651
See Here:-

Connect To A SQLite Database With VBA In Excel​

 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 05:06
Joined
Jul 9, 2003
Messages
14,651
I am now trying to figure out how the android connect to the Win PC SQLite backend database through the wifi.

I think I might have got the wrong end of the Stick as usual! Re-reading your question, I'm wondering, because you're using Android, I'm wondering if you should consider using something like Firebase? You can link firebase to MS Excel, and if you can link it to excel then you can probably link it to MS Access... See this Link:-

 

Users who are viewing this thread

Top Bottom