Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Locking open files

Status
Not open for further replies.

hillboy

Technical User
May 13, 2002
53
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"?
 
What type of file are you talking about? -Brad
A+, MCSE NT4, MCDBA SQL7

-Best cartoon of all time :-D 'Spongebob Squarepants' [cook]
 
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.

Is this an attribute setting?
 
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' [cook]
 
Thanks for responding BradSQLGuy......that's exactly what I needed to know.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top