Add support for MS Access 2007 Format - Needed for OOo

[Chris Cheney]

Binary package hint: shared-mime-info

I saved out test files for every format that MS Access 2007 supports saving and used gvfs-info to report what it thought about each file. It appears that the MS Access 2007 format itself is not supported yet. I will attach a zip file with all formats MS Access 2007 can save out to:

This one needs to be improved:

example - Microsoft Office Access 2007 Database.accdb : application/octet-stream - application/octet-stream

I will also have additional bugs for Excel/PowerPoint/Word file formats.

Thanks!

Chris Cheney

[ynamestnikov (ynamestnikov)]

In new OO 2.4 was added support for Access 2007 (.accdb files)

[Chris Cheney (ccheney)]

This bug is about the fact that shared-mime-info doesn't know what type of file an Access 2007 file is, so when you click on it, it thinks it is a 'octet-stream' file instead of something more usable like 'vnd.openxmlformats-officedocument.database' or something along those lines...

[berg (berg-foss)]

@cris
I think that I understood your idea: the objective is "know" what file is. "Work" with the file or "open" this file is a openoffice's ( koffice, abiword etc) problem ( a big ooxml problem - ISO raped :)

http://avi.alkalay.net/2008/03/how-microsoft-raped-iso.html

linking bugs:
https://bugs.launchpad.net/ubuntu/+source/shared-mime-info/+bug/208062
https://bugs.launchpad.net/ubuntu/+source/shared-mime-info/+bug/208071
https://bugs.launchpad.net/ubuntu/+source/shared-mime-info/+bug/208092
https://bugs.launchpad.net/ubuntu/+source/shared-mime-info/+bug/208096

[Andres Mujica (andres.mujica)]

Hi, should we mark this linked bugs as duplicate off bug #138252 or viceversa? it seems that this set of bugs are being worked on??

[Joe Smith (yasumoto7)]

This is actually a different issue, #138252 is discussing a different filetype, and it looks like the fix has already been released.

[Sebastien Bacher (seb128)]

the mdb example are correctly detected as application/vnd.ms-access in jaunty

[Sebastien Bacher (seb128)]

the accdb is still not reconized, lowering the settings since that's not a high importance issue

[Grzegorz G. (grzesiek1e5)]

All but accdb recognised in Precise.

[Sergey "Shnatsel" Davidoff (shnatsel)]

Created attachment 67696
Example of Access 2007 file

MS Office Access 2007 files are not recognized.

example - Microsoft Office Access 2007 Database.accdb:
 name: application/octet-stream
 data: application/octet-stream
 file: application/octet-stream

This bug was originally reported at https://bugs.launchpad.net/ubuntu/+source/shared-mime-info/+bug/208096

[Bugzilla-x (bugzilla-x)]

Caolan, does LO know how to open that?

[Sergey "Shnatsel" Davidoff (shnatsel)]

According to http://www.libreoffice.org/features/ it does.

[Sergey "Shnatsel" Davidoff (shnatsel)]

Oh wait, that doesn't mention 2007 explicitly, sorry.
http://wiki.openoffice.org/wiki/Connecting_to_Microsoft_Access does.

[Caolanm (caolanm)]

caolanm->dtardon: don't we only support msaccess under windows via ado or some such ?

[Dtardon (dtardon)]

(In reply to comment #3)
> Oh wait, that doesn't mention 2007 explicitly, sorry.
> http://wiki.openoffice.org/wiki/Connecting_to_Microsoft_Access does.

Have you actually _read_ the text? The first two sentences are: "These article describes how to connect to a Microsoft Access database file, if you use a MS Windows operating system. For other systems the solutions are not yet finished." ("not yet finished" should better be replaced by "not even started")

http://www.libreoffice.org/features/ is misleading, unfortunately. It should state that MS Access DB driver is only available on Windows. (It should also not mention Adabas, because the code has been removed and it is not clear if it had ever been compiled anyway.)