1. Forum
  2. DOVE-Net
  3. Tech

  • 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
  • From Ogg@VERT/CAPCITY2 to Foriest Jan Smith on Sun Jan 4 09:17:00 2026
    Hello Foriest Jan Smith!

    ** On Monday 29.12.25 - 23:20, Foriest Jan Smith wrote to All:

    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 worked with Access 2003 and "upgraded" to Access 2007 and
    that was a bit of a pain as many macros/forms had to be
    reprogrammed!

    Meanwhile, I too would like to have the .accdb and its many
    existing forms be useable from Libre Base or similar on a *nix
    system instead of MSOffice/Windows.

    Any progress so far with your dilema?


    --- OpenXP 5.0.64
    * Origin: Ogg's Dovenet Point (723:320/1.9)
    * Synchronet * CAPCITY2 * Capitol City Online
  • From Foriest Jan Smith@VERT/CJSPLACE to Ogg on Mon Jan 12 23:23:28 2026
    Re: Libre Base to Access 2003 DB Connection?
    By: Ogg to Foriest Jan Smith on Sun Jan 04 2026 09:17 am

    Any progress so far with your dilema?

    No, for now I gave up.
    ---
    ■ Synchronet ■ CJ's Place, Orange City, FL - cjsplace.thruhere.net