Open an Access (2003-2007) database in LibreOffice base

Open an Access (2003-2007) database in LibreOffice base

Hey there you guys!

How are you doing today? I hope you are great!

Have you ever tried to open a database file created by Microsoft only to find it looking like this: 




I have! And it sucks!

First of all this isn’t even Base! It’s Writer! And second of all: This is garbage!

Why does it look like this?

Luckily I was able to figure it out! It’s really simple! And it works for 2003 / 2007 (2010 doesn’t work, I tried :/).

All you have to do is to navigate to File New Database






From this window select (Connect to an existing Database) and select Microsoft Access 2003 or 2007 ( in this tutorial it was 2003).



Browse to where your Database is located. In this tutorial it’s in the D:






Save and proceed just like you would do with a normal database. And it’s open!



You notice that you saved an ODB database. Why is that?

Because you aren’t really opening an Access 2003 database. You are “Connecting” to it!

You must not delete the database. Or else you won’t be able to access your data!

But I want it to be opened just like a normal database. I don’t want to “connect” every time I edit my database!

Well there is a way for that too!

While this connected database is open, create a new database.

Copy the whole table. And paste it into the new database you just created!

You can keep the keys as is, or change them to meet your needs!

And save the newly created database!

As simple as that! Hope you like it. Drop a line below and let me know! Join my blog and subscribe to my mailing list so you don’t miss a post! NEW!!