Solved

Files and folders appear to be read-only in a shared folder (Windows 2003 Server)

Posted on 2009-05-08
8
213 Views
Last Modified: 2013-12-04
I have a file server (2003 Storage edition). There are a few shares. Setup with Full control as Shared persmissions and Modify on NFTS for a security group.
Almost from day one, users complaint that, once in a while, they get a message similar to this:"File has been modified by another user, would you like to save a copy or overwrite? when they work with file like Excell 2003.  In Access 2003 database, a message may appear Could not save; currently locked by another user. Similar behariour occurs with folders.
I would blame Access internal settings if the issue did not span other files
It is a small office, so there is no change that the file/folder/database are opened by someone else. That includes me checking Shared Folder Management utility.
Any suggestions are appreciated.
0
Comment
Question by:pfarber22
8 Comments
 
LVL 11

Expert Comment

by:Abhay Pujari
ID: 24337001
My suggestion is just modify your shared and NTFS permissions again. Instead of granting everyone full shared permissions, add individual user and then grant required permission. Similarly repeat this for NTFS permissions.
0
 
LVL 6

Expert Comment

by:CarlPritchard
ID: 24337017
Not a solution but we have the same problem when working with larger Excel files - this appears to be a file locking problem that has developed as our server has become older and computers faster. It seems to mostly affect the fastest PCs (and certainly my quad core).

As I said, this is not a solution but I would suggest that it is a functional problem (related to server capacity and PC speed) rather than a settings issue in Access or a permissions problem.

For us, since it mainly affects the two most technically savey people we tend to just live with it (I find that the files usually unlock after a short while anyway).
0
 
LVL 1

Author Comment

by:pfarber22
ID: 24337283
abhvp,
This approached recently worked for me, so I just did it and asking people to test it.
0
 
LVL 1

Author Comment

by:pfarber22
ID: 24337346
CarlPritchard,
I my situation, it is a brand new Dell server and a Dell Optiplex 750, and relatively small files, so it shouldn't be a communication issue.
Thanks for a reply.
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 38

Expert Comment

by:ChiefIT
ID: 24337458
I think the problem is, folks move files to the DFS share rather than copy these files to them. What happens is they end up in the DFS space with the permissions of the file creator. So, the editor has no ownership of the file and therefore no control over it. I have thought about this from time to time on how ownership and file permissions are not followed with someone who moves files directly into the share. If this is a single folder, use things like "append these attributes to all child objects" and "allow all child objects to accept permissions from the parent folders".

0
 
LVL 1

Author Comment

by:pfarber22
ID: 24374851
ChiefIT,
I will check andapply your suggestion  if they are not there which seems very logical. Just for the record, there was no creation or copying. All issues occured on the pre-existing files.
0
 
LVL 38

Expert Comment

by:ChiefIT
ID: 24393819
I had this same issue and was able to overcome it. When building the DFS namespace, the default share permission for the entire namespace is Read Only. So, you may have to rebuild the namespace and when selecting the folders that your going to be using in the namespace, makesure you edit thes to grant either full control or read, write and modify.
0
 
LVL 1

Accepted Solution

by:
pfarber22 earned 0 total points
ID: 24422741
It appears that removing Mac sharing from a folder in question resolved the issue. I am waiting on the end users to test it.
0

Featured Post

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I use more than 1 computer in my office for various reasons. Multiple keyboards and mice take up more than just extra space, they make working a little more complicated. Using one mouse and keyboard for all of my computers makes life easier. This co…
If your app took Google’s lash recently, here are the 5 most likely reasons.
Video by: Tony
This video teaches viewers how to export a project from Adobe Premiere Pro and the various file types involved.
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now