AnsweredAssumed Answered

Doesn't Alfresco handle MS Access files?

Question asked by imdea on Sep 13, 2012
Latest reply on May 20, 2016 by patrickvanhoof
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” type available in the drop-down list.

2)    In Windows XP, when trying to edit the .accdb files through the Windows Explorer WebDav connection using Access 2007, the files are open read-only. This does not happen with Word, Excel and PowerPoint files. Since the file is open read-only, it is not blocked for editing, allowing other users to edit it.

3)    In Windows XP, when trying to save the read-only file with another name through WebDav, the following error message appears: “You cannot use an Internet address here. Enter a path that points to a location on your computer or on the network”

4)    In Windows 7, the .accdb files can be opened in edit mode through the Windows Explorer WebDav connection using Access 2007. However, the program is slow opening the files. There is a new small file created in Alfresco (~1 KB) with the same name as the file being edited and with an extension .laccdb. It has a small lock icon.

5)    In Windows 7, when trying to save the file to the WebDav directory with with another name, the following error message appears: “Not a valid file name”. Saving the file with the same name by clicking on the “save” button in MS Access works ok.

Is there a way to solve this?

Thanks in advance.

Outcomes