MDB Support

  1. 9 weeks ago

    Chris H

    Apr 2 Testers, Xojo Pro Grand Rapids Michigan

    Anyone have success opening an MDB file on a Mac?
    I'm hoping to not need to connect to a Windows system with ODBC.

  2. Paul L

    Apr 2 Xojo Inc, Third Party Store
    Edited 8 weeks ago

    I believe you can do it with ODBC on Mac.

    These folks have a driver: http://www.actualtech.com

    Perhaps there are others.

  3. Chris H

    Apr 2 Testers, Xojo Pro Grand Rapids Michigan

    Is it possible to access an MDB from xojo on Windows without ODBC?

  4. Paul L

    Apr 2 Xojo Inc, Third Party Store
    Edited 9 weeks ago

    You can using ADO. There's an example here:
    Examples/Platform-Specific/Windows/LoadMSAccessUsingADO

  5. Paul B

    Apr 2 Testers, Xojo Pro Europe (UK, Somerset)

    @Chris H Is it possible to access an MDB from xojo on Windows without ODBC?

    Yes, as long as you have the latest Access drivers installed which will also open the newer accdb files.

  6. Chris H

    Apr 2 Testers, Xojo Pro Grand Rapids Michigan

    thanks all!

  7. Christian S

    Apr 2 Testers, Xojo Pro, XDC Speakers, Third Party Store Germany

    ODBC via MBS Xojo SQL Plugin on Windows with Microsoft Access driver works for me.

  8. Norman P

    Apr 2 Testers, Xojo Pro outside LMAO !!!!!!!

    @Chris H Anyone have success opening an MDB file on a Mac?

  9. Paul F

    Apr 3 Xojo Pro Europe, Cambridge

    If you only need to read MDB files on the Mac then the driver from Actual Technologies should work fine.
    I managed to be able to read and write to MDB files on the Mac using a combination of this platform-independent java driver:
    link text

    and the MBS Java Plugin from Christian.

    They are not free but worked perfectly and speed was pretty decent too.

  10. 8 weeks ago

    Jean-Yves P

    Apr 3 Testers, Xojo Pro Europe (France, Besançon)

    there are apps around to convert mdb to sql(ite) and then use sqlite instead. easier and free on all platforms.

  11. 5 weeks ago

    Chris H

    Apr 29 Testers, Xojo Pro Grand Rapids Michigan

    Jean-Yves,

    Can you suggest one (or more)? I’m not seeing anything that is viable. This could be optimal if I can embed it in my application or even have it running behind the scenes on the Xojo cloud.

  12. Paul B

    Apr 29 Testers, Xojo Pro Europe (UK, Somerset)

    I use Navicat to convert access to sqlite.

  13. Jean-Yves P

    Apr 29 Testers, Xojo Pro Europe (France, Besançon)

    with source code :
    https://sourceforge.net/projects/axbase/
    https://xiph.org/positron/doc/mdb.html
    https://code.google.com/archive/p/mdb-sqlite/
    https://github.com/arturasn/mdb2sqlite
    https://www.codeproject.com/Articles/314/Universal-Table-Editor
    https://github.com/brianb/mdbtools

    and the apps-only :
    https://apps.apple.com/kw/app/mdblite/id487704620?mt=12
    http://www.alexnolan.net/software/mdb_viewer_plus.htm
    more expensive :
    https://apps.apple.com/fr/app/accdb-mdb-explorer-open-view-export-access-files/id577722815?mt=12

    hope this helps.

or Sign Up to reply!