How can I make sure that open network files are locked so that additional users (all users except the 1st user)attempting to access the file are only allowed to open the file as "Read-only"?
Standard Office files (mainly Word and Excel files).
I am asking because the are inconsistencies on our files. Some prompt the user that the file is open and could only be viewed as "Read Only" whereas other files can be opened and written to by multiple users simultaneously.
Actually by default Word has something built in that when opened accross say..a network drive that person can edit that document. When someone else tries to open the same document while open it will let them know that the file can be opened 'read only'. Excel is a little bit different. You need to set those specific permissions up by excel protection or excel sharing. Also the creator of the document in excel can track changes and accept the ones they want. It will keep a copy of all the changes made with the initials of the person (whoever is registered in Windows)who made that change. Unfortunately there is no way to set up 'read only' access on Windows Client or on the Server for users opening the document simultaniously. That is built in Office applications by default. Does that help? -Brad
A+, MCSE NT4, MCDBA SQL7
-Best cartoon of all time :-D 'Spongebob Squarepants'
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.