I have a Linux box that I use as file server within Windows 2003 domain. One folder contains MS Access database, which needs to be open simultaneously by multiple users. What happens is, when u access database, it creates intermediate file, that allows everyone to access it.
This file is created automatically when first user opens database, and deleted automatically, when last user closes database.
I have set permissions on the folder and on all files within it, to allow read write, but when ever this new file is created, it is created with write permissions for the user that opened it first, and in order for other to access it, I have to go and manually give that file write permissions for the other users. Next day it starts all over again
Any suggestions are greatly appreciated.