How to protect my database

  • Thread starter Thread starter hrbsh97
  • Start date Start date
H

hrbsh97

I have a personnel database that I have developed .. I would like to share
this database for others to use for information lookup in Access and for use
in Word documents (merges & such) .. I am planning on putting this database
out on our server on a shared folder. I don't mind who uses it .. however,
here is the biggie .. I would like to restrict it so that users can view &
use in Word but not change my design or add/delete information. What is the
simplest/best way to do this? ..

I would appreciate any help you could all give me :) .. thanks!
 
hrbsh97 said:
I have a personnel database that I have developed .. I would like to share
this database for others to use for information lookup in Access and for
use
in Word documents (merges & such) .. I am planning on putting this
database
out on our server on a shared folder. I don't mind who uses it ..
however,
here is the biggie .. I would like to restrict it so that users can view &
use in Word but not change my design or add/delete information. What is
the
simplest/best way to do this? ..

I would appreciate any help you could all give me :) .. thanks!
Click to expand...

I would say the simplest way is to split the database and supply each user
with an mde front end with the bypass key disabled, all startup options
disabled, and provide custom menus.

Protect your back end the same way and by putting it on a hidden share with
delete file permissions removed.

HTH - Keith.
www.keithwilby.com
 
Thanks for the reply :) ..

You mentioned the following:

mde front end with the bypass key disabled, all startup options disabled,
and provide custom menus. You also said to protect your back end the same
way and by putting it on a hidden share with delete file permissions removed.

Can you give me more information on how to do this? .. or point me in the
right direction to find out how to do this? ..

Many thanks!!!
 
hrbsh97 said:
Thanks for the reply :) ..

You mentioned the following:

mde front end
Click to expand...

Create an mde file using the Tools, Database Utilities menu item.
with the bypass key disabled,
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

all startup options disabled,
Click to expand...

Uncheck all options under Tools, Startup.
and provide custom menus.
Click to expand...

You need to create your own menus because you are removing the option to
show built-in menus at startup so that users can't access your db window.
You also said to protect your back end the same
way and by putting it on a hidden share with delete file permissions
removed.
Click to expand...

You need server admin rights to do this but you map a network folder, share
it (it will have a "$" suffix) and hide it. Use folder permissions to
remove evberyone's (except yours) ability to delete the BE.

If none of this means anything to you then please practice on dummy files,
you could very easily screw up.

HTH - Keith.
 
Back
Top