Android Question .db file (sqlite) & .mdb file (vb6)

trepdas

Active Member
Licensed User
Hello good people,

My sincere apologies for the (probably) dumb question ahead :


Can the datautils library handle database files created in vb6 ? (mdb files).

does b4x treats it as sqllite's db file?

(the mdb file is most likely being created with microsoft's ms access)

rephrasing the question :
will renaming .mdb files to .db files will work?

Thxx
 

asales

Expert
Licensed User
Longtime User
As the access database is in your computer, the better solution is to create a server in B4J.
Maybe you can start here:
 
Upvote 0

aeric

Expert
Licensed User
Longtime User
Upvote 0

AlpVir

Well-Known Member
Licensed User
Longtime User
I don't know if it can be useful but there is also the possibility, with a program developed in VB6, to transform a .mdb archive into a .sqlite one
 
Upvote 0

KMatle

Expert
Licensed User
Longtime User
You can export all the tables as *.csv files and recreate them in SQLite (or any other db). Same for indexes or other relations. Of course you need knowledge about SQL. With B4J you can "play with it" (easier to debug) until you get good resuts. I assume we're talking about a small database as mobile phones are not made to handle big databases.

If we're talking about some 100 rows, maybe a LIST or a MAP will do, too. Or a file with the data (because you need to deploy the app WITH the data or download it from somewhere). Here csv-files are good, too (in assets).
 
Upvote 0
Top