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

[trepdas]

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

 

[Mahares]

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

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

 

[asales]

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

Opening MS Access databases (mdb)

1. Download UCanAccess: https://www.b4x.com/b4j/files/ucanaccess.zip (Sources: https://jackcessencrypt.sourceforge.io/ and http://ucanaccess.sourceforge.net/site.html) The libraries are licensed with Apache 2.0 license: http://www.apache.org/licenses/LICENSE-2.0 2. Copy the jars to the...

www.b4x.com

 

[aeric]

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

You mean DBUtils?

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

database files created in vb6 ? (mdb files)

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

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

It won't work

 

[aeric]

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

 

[trepdas]

You mean DBUtils?

- yes.



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


It won't work

Thx ?

 

[AlpVir]

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

 

[KMatle]

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