Security Wizard

  • Thread starter Thread starter Greg Ripper
  • Start date Start date
G

Greg Ripper

How do I keep people from clicking on the toolbar at the bottom and just looking
at the data, forms, etc, in my database.

I have 40 users who will enter new data and only need to look at a series
of forms. I tried going through the security wizard in Access 02, but if
I block them access to tables, they cannot enter new data in those tables.

I am very frustrated by this and have very little hair left to pull out.

Thanks as Always,
Rip
 
If you want to implement user security, you can create queries set to run
with owner permissions. Give the users permission to use the queries, and
you can remove all permissions from the table.

If you don't want to implement security, there are a number of things you
can do to keep the curious out.

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)

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

You can also create a MDE from your database, which will prevent changes to
forms, reports and modules (If you do this, be certain to keep your original
mdb in case you need to make changes).

None of this will keep the determined out. All they need to do is start a
new db and link to your's, but this may suffice for your purposes.
 
Thanks for the excellent advice, Joan. I do most or all of the things
myself.

One thing--you said all that won't keep the determined out. How DO you keep
the determined out?

LRH
 
Larry R Harrison Jr said:
Thanks for the excellent advice, Joan. I do most or all of the things
myself.

One thing--you said all that won't keep the determined out. How DO you keep
the determined out?

LRH
Click to expand...

Switch to a server database for the backend (SQL Server for eg.). Access
can still be used as the frontend.

I personally have not come up against someone that determined. All my
clients consider their database as a tool to help them do their job; and I
build into my applications whatever they need. They really aren't
interested in hacking into it.
 
Back
Top