Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

I have a .accdb file created with Microsoft Office 2010 and I want to know if it is possible to open it with some native Ubuntu application like LibreOffice or OpenOffice, I know LibreOffice has LibreOffice Base but I can't figure out how to open or if it's even possible to open a .accdb file.

Is there anyway I can open a .accdb file without Wine or VirtualBox?

share|improve this question
add comment

2 Answers

up vote 3 down vote accepted

As mentioned here it says it supports Access files but if we look deeper they have only tested in LibreOffice up to Office 2007.

Since you have an Office 2010 I would suggest trying out this link since other users by the look of this have already tried.

Additionally the compatibility shown here says how good LibreOffice Base is when relating to Microsoft Access 2010. At least up to version 3.6.

There is also a question on the Ask Libreoffice site about this that mentions this link where it is said that the 2007 format is different from the 2010 so it will not work correctly in LibreOffice 3.6 or below.

My only recommendation that does not include Wine or VirtualBox would be to use MS Office 2010 to save the Access file as a 2007 version (If possible) or a MDB format. At least while LibreOffice works on improving compatibility with 2010 in general.

share|improve this answer
add comment

I know this reply may be a bit late but I must write it down for future documentation if anyone would look it up.

When it comes to develop apps in Base as you were doing in MS-Access, I think you would find Gambas to be a better solution. Gambas is an open source alternative for Visual Basic (please visit this link). I know that they have improved their IDE since version 3.x and it is on stable release.

Gambas has great & simple connectivity to MySQL (My favorite) and to PostgreSQL. Plus, it has multi socket capability and much more.

In the long run, if you have any experience with VB at all, and you are willing to invest several hours to get to now the new VB IDE and coding rules (which are not much different from MS), I would strongly suggest trying Gambas.

share|improve this answer
    
This isn't relevant to the question posted here. –  nikhil Nov 28 '12 at 8:12
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.