• Libre Base to Access 2003 DB Connection?

    From Foriest Jan Smith@VERT/CJSPLACE to All on Mon Dec 29 23:20:06 2025
    I've recently been messing with Access 2003, and for better or worse I've accidentally created a DB I rely on in my life in it. I've been trying to find if there's ANY way to connect to the DB with Libre Base; any attempts have failed.
    ---
    þ Synchronet þ CJ's Place, Orange City, FL - cjsplace.thruhere.net
  • From Bf2k+@VERT/TACOPRON to Foriest Jan Smith on Tue Dec 30 07:35:34 2025
    Re: Libre Base to Access 2003 DB Connection?
    By: Foriest Jan Smith to All on Mon Dec 29 2025 11:20 pm

    I've recently been messing with Access 2003, and for better or worse I've accidentally created a DB I rely on in my life in it. I've been trying to find if there's ANY way to connect to the DB with Libre Base; any attempts have failed.

    I'd like to know this myself...

    ---
    þ Synchronet þ TIRED of waiting 2 hours for a taco? GO TO TACOPRONTO.bbs.io
  • From nblade@VERT/ECBBS to Bf2k+ on Tue Dec 30 11:00:00 2025
    Well from what I've quickly been reading, It depends.

    If you are on a Windows machine (I for full disclosure am not), then
    it seems you can setup an OBDC connection for it.

    On other machines, then it seems like you might be able to use the
    JDBC driver UCanAccess, althought personally I am not familar with it.

    Another option might be to see if you can export all the Access tables to
    CSV and see if you can then import them into a new Database. Of course
    that is a lot of work.

    Still another option that may or may not work is to convert the Access DB
    into something like an SQLite DB. Again if you are on a Windows machine,
    you can find and install an SQLite DB ODBC driver and then in Access
    export to the Database to the SQLite DB ODBC source.

    Good Luck and let us know if you ever find a solution that works for you.


    Bf2k+ wrote to Foriest Jan Smith <=-

    Re: Libre Base to Access 2003 DB Connection?
    By: Foriest Jan Smith to All on Mon Dec 29 2025 11:20 pm

    I've recently been messing with Access 2003, and for better or worse I've accidentally created a DB I rely on in my life in it. I've been trying to find if there's ANY way to connect to the DB with Libre Base; any attempts have failed.

    I'd like to know this myself...

    ---
    = Synchronet = TIRED of waiting 2 hours for a taco? GO TO TACOPRONTO.bbs.io

    ... Computer Hacker wanted. Must have own axe.
    --- MultiMail/Linux v0.49
    þ Synchronet þ electronic chicken bbs - bbs.electronicchicken.com