back end security

[Guest]

I have a front end/ back end data base in access 2003, I have secured the
front end with password and convert to mde and disable shift bypass key, my
question is how can I prevent back end from accidental or deliberate deletion.

Thanks in advance

 

[Keith Wilby]

I have a front end/ back end data base in access 2003, I have secured the
front end with password and convert to mde and disable shift bypass key,
my
question is how can I prevent back end from accidental or deliberate
deletion.

Thanks in advance

There are a couple of precautions you can take. First, put the BE in a
hidden folder. Next, set the NT file permissions on the *file* to RWX (ie
NOT delete) - be sure not to do this on the folder since all users need RWXD
permissions to handle the record locking file.

HTH - Keith.
www.keithwilby.com

 

[Keith Wilby]

Oh, and secure the BE of course!

 

[Joan Wild]

There are a couple of precautions you can take. First, put the BE in a
hidden folder. Next, set the NT file permissions on the *file* to RWX (ie
NOT delete) - be sure not to do this on the folder since all users need
RWXD permissions to handle the record locking file.

Just be aware that after you compact the BE, you'll need to reset the
permissions on the file, as it will inherit the permissions from the folder.

Securing the backend won't prevent its deletion.

 

[Guest]

Hi Keith,
Back end file is already in a hidden folder but as you know its very simple
to show the hidden files and I have checked most of the people has checked
that option "show hidden files" so most of them can see that I put the back
end in the hidden folder. I like the idea of setting the permission to RWX
but how can I set the NT file permission on the file to RWX. I dont fully
understand this, please help.
also is it possible that I can make the back end password protected so that
no one can directly open the back end?

Thanks
Rashid

 

[Keith Wilby]

Hi Keith,
Back end file is already in a hidden folder but as you know its very
simple
to show the hidden files and I have checked most of the people has checked
that option "show hidden files" so most of them can see that I put the
back
end in the hidden folder. I like the idea of setting the permission to RWX
but how can I set the NT file permission on the file to RWX. I dont fully
understand this, please help.

It depends on what operating system you are using but you need to
right-click the file and choose "properties" then go to the security tab.
How you set the permissions then depends on which OS you're using but
proactise on a dummy file first in case you deny yourself permission to it.

also is it possible that I can make the back end password protected so
that
no one can directly open the back end?

You need to secure your BE using the same workgroup file as the FE. The
easiest way is to join your custom workgroup, create a new file and them
import your tables into it.

HTH - Keith.
www.keithwilby.com