Doesn't Alfresco handle MS Access files?

imdea — Thu, 13 Sep 2012 09:47:37 GMT

Hello,I'm having some issues with MS Access files within Alfresco:MS Access files behavior in Alfresco:1) MS Access files (.accdb) are not recognized by Alfresco. The Content Type is set to “Octet Stream”. As a matter of fact, when trying to change the content type, there is no “Microsoft Access”

Re: Doesn't Alfresco handle MS Access files?

afaust — Thu, 13 Sep 2012 10:18:39 GMT

Hello,

most of the points listed conform to the Windows / Microsoft behaviour I have come to love over the course of my Alfresco career.

1) Indeed Alfresco is lacking a mimetype configuration for *.accdb files. This can be rectified by providing a configuration extension:


<alfresco-config area="mimetype-map">

   <config evaluator="string-compare" condition="Mimetype Map">
      <mimetypes>

         <mimetype mimetype="application/msaccess" display="Microsoft Access 2007">
            <extension default="true">accdb</extension>
         </mimetype>
      </mimetypes>
   </config>
</alfresco-config>
‍‍‍‍‍‍‍‍‍‍‍‍‍

and


<bean id="yourCustom.mimetype.config" class="org.springframework.extensions.config.ConfigBootstrap" init-method="register">
        <property name="configService" ref="mimetypeConfigService" />
        <property name="configs">
            <list>
                <value>classpath:alfresco/extension/yourCustom-mimetype-config.xml</value>
            </list>
        </property>
    </bean>
‍‍‍‍‍‍‍‍‍‍

2) For Office, there are a couple of registry settings that govern this behaviour - I didn't find any for Access. This is a purely client related limitation, since opening a file in XP via Web Folders (WebDAV client) by default behaves as if you'd downloaded a file from the Internet.

3) MS Access is apparently unable to handle WebDAV locations for save. This again is a client limitation, since XP and Web Folders do not expose WebDAV drives as "real drives" that any application can work with. The standard Office clients e.g. all have integrated WebDAV support as part of their SharePoint protocol support.

4) The .laccdb is most likely a temporary lock file created by MS Access to prevent concurrent access to the file by multiple users. It should be automatically deleted when Access is closed. Of course, if Access crashes, the file will remain and needs to be manually deleted from Alfresco.

5) No idea here - what is the name you attempted to use? Maybe it really is an invalid name..

Regards
Axel

Re: Doesn't Alfresco handle MS Access files?

patrickvanhoof — Fri, 20 May 2016 08:00:22 GMT

Still no support for uploading MS Access database files (.accdb)?

Re: Doesn't Alfresco handle MS Access files?

patrickvanhoof — Fri, 20 May 2016 08:20:48 GMT

I made a mistake, it is possible to upload .accdb files…

topic Re: Doesn't Alfresco handle MS Access files? in Alfresco Archive

Doesn't Alfresco handle MS Access files?

Re: Doesn't Alfresco handle MS Access files?

Re: Doesn't Alfresco handle MS Access files?

Re: Doesn't Alfresco handle MS Access files?