Disconnect an odb from mdb

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

Disconnect an odb from mdb

Postby bastereta » Thu Jul 30, 2015 12:18 pm

I have created an odb directly opening from an mdb file. Now, both are connected, and I want to delete mdb file, but when I delete mdb, odb is automaticly set to blanc (with no tables and no information).
LibreOffice (based on OpenOffice) on Windows 7 home premium (with SP1)
Posts: 1
Joined: Thu Jul 30, 2015 12:12 pm

Re: Disconnect an odb from mdb

Postby Villeroy » Thu Jul 30, 2015 12:35 pm

OK, disconnect from mdb and connect to what else?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Posts: 24398
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Disconnect an odb from mdb

Postby MTP » Thu Jul 30, 2015 5:09 pm

The .odb file only stores queries, forms, and reports. The actual tables are stored by a separate program, in your case Access/Jet.

Base has an option to use an "embedded" version of HyperSQL database (HSQLDB) where the HSQLDB program and all the files it uses to manage the tables are zipped inside the .odb file. This works for small to medium files that don't see a lot of activity; with a large file or frequent use the risk of dataloss bugs due to the "embedding" becomes greater.

You could create a new Base file and drag & drop the tables from your connected .mdb file into the new file. This would attempt to convert the Jet database into a HSQLDB database; the success of the conversion would depend on what kind of data and columns you have. If successful, then you'd have your data in a database embedded inside the .odb file (so it would act like one file).
OpenOffice 4.1.1 on Windows 10, HSQLDB 1.8 split database
User avatar
Posts: 1618
Joined: Mon Sep 10, 2012 7:31 pm
Location: Midwest USA

Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 3 guests