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

trepdas said:

will renaming .mdb files to .db files will work?

Click to expand...

No. Absolutely not. It is not a dumb question either.

As the access database is in your computer, the better solution is to create a server in B4J.
Maybe you can start here:

trepdas said:

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

Click to expand...

You mean DBUtils?

Erel said:

DBUtils is a b4xlib with useful utilities related to the SQL library. It is designed to work with SQLite databases.

Click to expand...

database files created in vb6 ? (mdb files)

Click to expand...

Do you create the .mdb file using Jet JRO dll or MS Access?

trepdas said:

will renaming .mdb files to .db files will work?

Click to expand...

It won't work

I recommend you learn from SQL Tutorial
It is easy to create sqlite db in B4X.

aeric said:

You mean DBUtils?

- yes.



Do you create the .mdb file using Jet JRO dll or MS Access?
with ADOX.Catalog


It won't work

Click to expand...

Thx ?

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

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).