Add support for MS Access 2007 Format - Needed for OOo

Bug #208096 reported by Chris Cheney on 2008-03-28
10
Affects Status Importance Assigned to Milestone
shared-mime-info
Invalid
Medium
shared-mime-info (Ubuntu)
Low
Unassigned
Hardy
High
Unassigned

Bug Description

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

Chris Cheney (ccheney) wrote :
Changed in shared-mime-info:
importance: Undecided → High
milestone: none → ubuntu-8.04
ynamestnikov (ynamestnikov) wrote :

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

Chris Cheney (ccheney) wrote :

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) wrote :

@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

Chris Cheney (ccheney) on 2008-04-01
Changed in shared-mime-info:
milestone: ubuntu-8.04 → none
Changed in shared-mime-info:
status: New → Confirmed
Chris Cheney (ccheney) on 2008-05-08
Changed in shared-mime-info:
milestone: none → ubuntu-8.10-beta
Andres Mujica (andres.mujica) wrote :

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) wrote :

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) wrote :

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

Changed in shared-mime-info:
importance: High → Low
milestone: ubuntu-8.10-beta → none
Sebastien Bacher (seb128) wrote :

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

Grzegorz G. (grzesiek1e5) wrote :

All but accdb recognised in Precise.

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

Changed in shared-mime-info:
importance: Undecided → Unknown
status: New → Unknown
Changed in shared-mime-info (Ubuntu):
status: Confirmed → Triaged
Changed in shared-mime-info (Ubuntu Hardy):
status: Confirmed → Won't Fix
Changed in shared-mime-info:
importance: Unknown → Medium
status: Unknown → Confirmed

Caolan, does LO know how to open that?

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

(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.)

Changed in shared-mime-info:
status: Confirmed → Invalid
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.