locking down a databse

[Guest]

I want to know what steps I need to take to lock down a database so users can't design new things or mess up already designed reports/queries. forms, etc...

I want to know how to hide the toolbars, restrict people from getting into the design and even from seeing some forms and such that I don't want them to play around with.

I also want to know how after I button everything up I can go in at a alater date and make modifications if neccesary.

I want to make this database look like a piece of software you buy from a third party vendor. I know a little about the "hidden properties" of database object but am a novice to this sort of thing.

Do I need to set passwords? and if so can I set a password for this one database alone and not have to create a Security.mdw that everyone needs to be mapped to since some clients may have different permissions due to the different databases they use. i.e. the AP clerk could have design rights to her own AP database but I don't want to grant her full access to my database that we all share officewide?

thanks

 

[Joan Wild]

I want to know what steps I need to take to lock down a database so
users can't design new things or mess up already designed
reports/queries. forms, etc...

You can create a mde from your mdb - users will not be able to make design
changes to forms/reports. If you do this, be sure to keep your mdb so that
you can make and changes.

I want to know how to hide the toolbars, restrict people from getting
into the design and even from seeing some forms and such that I don't
want them to play around with.

Backup your database; you can easily lock yourself out playing around with
these features.

Create custom menus/toolbars for use throughout your application.
Create a startup form (a main menu form if you have one) that is opened on
startup.
Use the features in Tools, Startup to
set the startup form
set your default menu (the custom one you made)
disable all the checkboxes about allowing built in menus, toolbars,
changes etc.
hide the db window (ensure the custom menu you create does not
include the Windows, Unhide item)
Click on the Advanced button and uncheck the allow special keys
(this will disable the F11 key, among others)

I also want to know how after I button everything up I can go in at a
alater date and make modifications if neccesary.

If you need to bypass these startup features, you can hold the shift key
down while you open the db. If you feel that your users may use this to
bypass your settings, you can disable the shift key bypass - there's an
example in help for doing this(look for AllowBypassKey) or at
http://www.mvps.org/access/modules/mdl0011.htm
and
http://www.mvps.org/access/general/gen0040.htm