I have a few LibreOffice Base .odb files I created for someone and we are having problems where when one user opens and edits the file, and closes it, then it is now read-only for other users. I then have to create a copy and trash the locked file so they can use it, but then again it becomes locked to anyone else and they too end up having to make a copy. I have set permissions accordingly in the folder and file properties yet it still gets locked as soon as anyone makes a change, now only they can edit it further. It’s turning out to be a major pain in the butt. The files are stored on a desktop and accessed via network by 3 other computers. We are running Ubuntu 12.04 and LibreOffice 220.127.116.11. (I cannot update to 4.0.4 due to a bug in the report builder causing it to crash). I also tested it at home with Ubuntu 13.04 and LO 18.104.22.168 and got the exact same results from my computers. I found this in ReadMe:
“File locking is enabled by default in LibreOffice. On a network that uses the Network File System protocol (NFS), the locking daemon for NFS clients must be active. To disable file locking, edit the soffice script and change the line “export SAL_ENABLE_FILE_LOCKING” to “# export SAL_ENABLE_FILE_LOCKING”. If you disable file locking, the write access of a document is not restricted to the user who first opens the document.
Warning: The activated file locking feature can cause problems with Solaris 2.5.1 and 2.7 used in conjunction with Linux NFS 2.0. If your system environment has these parameters, we strongly recommend that you avoid using the file locking feature. Otherwise, LibreOffice will hang when you try to open a file from a NFS mounted directory from a Linux computer.”
I could not find SAL_ENABLE_FILE_LOCKING where described but I found it in etc/libreoffice and changed FILE LOCKING=auto to =no on both computers and it did not work, not only that it got an error and would not even open the forms, let alone edit anything in it.