Protecting files from being deleted, renamed & moved. But data entry possible

E

Ed

Hi,

I have a group of 30 people who are supposed to enter their personal
folder on a shared drive, put their monthly data into an excel file
and safe it.

Because the excel file is linked to a couple of other files they
shouldn't be able to delete, rename or move the file. Also they
shouldn't be able to create copies of it in the same folder or change
permissions, take ownership etc.

On the folder level I give full control to the individual user, which
I then curb under the advanced options (right click on
folder-properties-security- advanced)
Subfolders and files inherit the settings.
To restrict the creation of new files and folders, I deny "Create
Files/Write Data" and "Create Folders/append data". But now they can't
save the file anymore under the same name in the same folder...

Also, once they are done with their data entry, the file is saved
through a macro. Because I deny "delete" and "delete subfolders and
files" each time the macro runs it creates a scrap file in the
folder...

The system I use is Windows 2000 Professional.

Please could anyone let me know how to get round these problems?


Thanks for your help

Philipp
 
M

macropod

Hi Ed,

Since you know how to link workbooks, why not give each of the users their
own sub-set that they can update, in their own (designated) folders and to
which the one you're concerned about can link to for data consolidation
purposes. Then, the worst an errant user can do is stuff up their own copy.

Cheers
 
D

Doug Kanter

Ed said:
Hi,

I have a group of 30 people who are supposed to enter their personal
folder on a shared drive, put their monthly data into an excel file
and safe it.

Because the excel file is linked to a couple of other files they
shouldn't be able to delete, rename or move the file. Also they
shouldn't be able to create copies of it in the same folder or change
permissions, take ownership etc.
Click to expand...

Although you'll probably get a response here, this might get more attention
in the newsgroups which address Windows networks. But, I'll address the "no
delete" question another way, which doesn't deal with network issues.

1) I don't know what the job description is, but do they have a good reason
to be screwing around in Explorer or My Computer, or even THINKING about
permissions, deleting, etc? Would this be a reason to call an employee into
your office for a little chat about job security? And, I believe you can
eliminate access to Explorer and My Computer. Poke around this excellent
site: http://www.winguides.com/registry/. Just be sure that access is
removed for the normal users, but not for the admin account on each machine.

2) To screw up a file from the File-Open or File-Save boxes WITHIN Excel,
you have to go through steps which, if taken, would mean the damage was done
intentionally. Combine this with:

3) How often is your data backed up TO EXTERNAL TARGETS, such as tape,
CD-ROM, etc? You know it should be done daily. If this is done, and an
employee deletes a file, there will be a backup available from the previous
day so you only lose a day's work. After having to reenter all their work
from the current day, most employees learn pretty quickly.
 
Top