The development machine I work on has Ubuntu Jaunty Jackalope as its operating system. I have been presented with data for a project I'm working on in the form of an .accdb file created by Microsoft Access. I do not own a copy of Microsoft Access. I do have Open Office installed and would be willing to install any software package available to my operating system. Is there a way I can open or transform this file so that I can view and edit the data on my computer? Is there another format that the Access database could be saved as that I would be able to open?
+1
A:
This may be of interest: http://stackoverflow.com/questions/1440648/how-to-convert-accdb-to-a-postgres-database
I am not sure if Wine would suit, but it might be worth a look.
Remou
2009-11-30 21:11:05
A:
Im not sure if there are any native tools, but you can always install a copy of windows and install a free view for accdb files or install a trial of Access.
Henri
2009-11-30 21:11:23
yeah, you can _always_ install windows.
Malfist
2009-11-30 21:29:58
This is the expensive answer I was trying to stay away from.
pgwillia
2009-12-02 17:06:16
+2
A:
There are two open source tools available however they only work on MDB format files. Can you ask the supplier of the ACCDB file to give it to you in MDB format?
MDB Tools is a set of open source libraries and utilities to facilitate exporting data from MS Access databases (mdb files) without using the Microsoft DLLs.
Jackcess is a pure Java library for reading from and writing to MS Access databases. It is part of the OpenHMS project from Health Market Science, Inc. . It is not an application. There is no GUI. It's a library, intended for other developers to use to build Java applications. It appears to be much newer than MDB tools, is more active and has write support.
Tony Toews
2009-11-30 21:23:16
A:
I guess you want to extract data from tables, not code from modules. I do not know specifically Ubuntu but I guess you can connect to the access file using an ODBC connection (or, if available, OLEDB connection) and extract the data? Depending on the connection type, you might still need to know the tables names in order to import them.
Philippe Grondier
2009-12-01 10:16:42
Jet/ACE only runs on Windows, so you'd need some other library for replicating the functionality that Jet/ACE offers. Tony has offered all the ones that I'm aware of.
David-W-Fenton
2009-12-01 22:09:47
A:
Microsoft Access Runtime is a free software. You can install it in Ubntu using Wine and then open the accdb database.
Makada
2010-07-01 14:25:01
David-W-Fenton
2010-07-01 23:50:05