Database Security

  • Thread starter Thread starter Nick
  • Start date Start date
N

Nick

I have made this request before but i can't find my
original post.
I hop some one can help?

Can anyone tell me how to secure my database without using
passwords?
I would like to lock away all design access and the
database window. I only want access to the Main
Switchboard. I have tried *.mde but I can still access the
database window.

Is this possible?

Nick
 
Distribute the database in a runtime version. You will need to purchase the
Developer's Edition for your version to do this.
 
Nick said:
I have made this request before but i can't find my
original post.
I hop some one can help?

Can anyone tell me how to secure my database without using
passwords?
I would like to lock away all design access and the
database window. I only want access to the Main
Switchboard. I have tried *.mde but I can still access the
database window.
Click to expand...

Access to the db window and security are separate issues. User-Level
security would allow you to restrict permissions so that even though users
can access the db window they still can't do anything you don't want them
to. Security can be set up so that a special workgroup file and password
is required only for development work while normal users can use the file
without a logon. This basically involves giving the default group "Users"
whatever permissions you want normal users to have, but denying that group
any design rights.

You can use Startup options to "hide" the db window, but then you also have
to disable "special keys" in Startup as well so they can't just use F11 to
show the window. You also need to run some code on your file that disables
the Shift key at startup which would bypass all of your Startup settings.

A Google search on these groups for all of these topics should yield plenty
of references.
 
Back
Top