How to Secure the folder

12 Jun 2009 7:20 PM

nancye

I have a database with user lever security with a groups with Read Only
permissions and a group with Admin persmissions
..
Everyone in our office has network rights: Modify, Read, Write, Read &
Execute, and List Folder contents to the network folder where the database is
located.

How can I secure the folder so the database is not deleted or renamed or the
folder isn't deleted or renamed.

--
nancye

15 Jun 2009 8:12 AM

Keith Wilby

Show quote Hide quote

"nancye" <nan***@charter.net> wrote in message
news:E3E8AE21-1E10-4360-B08E-3CDB294E49AE@microsoft.com...
>I have a database with user lever security with a groups with Read Only
> permissions and a group with Admin persmissions
> .
> Everyone in our office has network rights: Modify, Read, Write, Read &
> Execute, and List Folder contents to the network folder where the database
> is
> located.
>
> How can I secure the folder so the database is not deleted or renamed or
> the
> folder isn't deleted or renamed.
>

Here's one way:

http://www.ss64.com/nt/cacls.html

Keith.
www.keithwilby.co.uk

15 Jun 2009 2:49 PM

nancye

But if a user must have read/write/delete to the folder where the database
resides, then there is no way to prevent them from deleting the database file
or renaming it, correct?

--
nancye

Show quoteHide quote

"Keith Wilby" wrote:

> "nancye" <nan***@charter.net> wrote in message
> news:E3E8AE21-1E10-4360-B08E-3CDB294E49AE@microsoft.com...
> >I have a database with user lever security with a groups with Read Only
> > permissions and a group with Admin persmissions
> > .
> > Everyone in our office has network rights: Modify, Read, Write, Read &
> > Execute, and List Folder contents to the network folder where the database
> > is
> > located.
> >
> > How can I secure the folder so the database is not deleted or renamed or
> > the
> > folder isn't deleted or renamed.
> >
>
> Here's one way:
>
> http://www.ss64.com/nt/cacls.html
>
> Keith.
> www.keithwilby.co.uk
>
>

15 Jun 2009 9:02 PM

Douglas J. Steele

It's possible to have Delete permissions on the Folder (so that
newly-created files inherit the permission), but not have Delete permission
on a specific file in the folder (although if you do this, recognize that
someone will have to have Delete in order to be able to compact the file)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

Show quoteHide quote

"nancye" <nan***@charter.net> wrote in message
news:51D28F30-AEF5-416D-8488-6EDA9F358DF9@microsoft.com...
> But if a user must have read/write/delete to the folder where the database
> resides, then there is no way to prevent them from deleting the database
> file
> or renaming it, correct?
> --
> nancye
>
>
> "Keith Wilby" wrote:
>
>> "nancye" <nan***@charter.net> wrote in message
>> news:E3E8AE21-1E10-4360-B08E-3CDB294E49AE@microsoft.com...
>> >I have a database with user lever security with a groups with Read Only
>> > permissions and a group with Admin persmissions
>> > .
>> > Everyone in our office has network rights: Modify, Read, Write, Read &
>> > Execute, and List Folder contents to the network folder where the
>> > database
>> > is
>> > located.
>> >
>> > How can I secure the folder so the database is not deleted or renamed
>> > or
>> > the
>> > folder isn't deleted or renamed.
>> >
>>
>> Here's one way:
>>
>> http://www.ss64.com/nt/cacls.html
>>
>> Keith.
>> www.keithwilby.co.uk
>>
>>