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

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

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

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