User rights in Access Database

[mdw233psu]

I have a database that is used for time and attendence (Login and
logouts). When you open the database the "Security Warning" pops up
(The prompt that warns you about unsafe expressions). When the user
clicks "OPEN" it takes them to the appropriate splash screen, but when
they hold shift as they click "OPEN", they can get to the
tables/reports/etc. How can I password protect this database so that
only people with the password can get to the objects in the database?

This is probably simple, but I cant figure it out.

 

[dbahooker]

it's not possible to secure MDB database or application

you should be using SQL Server

-Aaron
ADP Nationalist

 

[Bill Mosca, MS Access MVP]

This is a rather large topic. Using Access User-level security will do a
fairly decent job, but it takes some learning to get it all working properly
for you.

I suggest you read the document at
http://support.microsoft.com/support/kb/articles/Q165/0/09.asp, but before
you start implementing the steps, make a backup copy of your database, and
practice on a test database until you feel comfortable setting up the
security or you might lock yourself out of your own database.

 

[Barry Gilbert]

Several steps to make this happen:

You need to create and set the AllowBypassKey property in your database. If
you open BVA Help from the BVA window and search for AllowBypassKey, you'll
see some sample code on how to do it.

In the startup dialog (Tools, Startup), uncheck Display Database Window and
Show Built-in Menus. This will prevent users from seeing the database window
and from being able to use Window,Unhide to unhide the db window.

Next, create a macro and name it "autokeys". This macro allows you to assign
actions to keystroke combinations. Make the Macro name and Conditions columns
visible by using the View menu. In the Macro Name column, put {F11}. This
will override the default shortcut key to unhide the database window, but
will put a cheesy password on it. To do this, put this in the Conditions
column:
InputBox("Enter password") = "123"
where 123 is the password. Then in the Action column, put RunCommand. Down
below, put WindowUnhide. This will give you the Unhide dialog after putting
in the password.

A cautionary note here: Make a backup of your database before doing any of
this!!!

Another note: Read and follow the previous note!!

Hope this helps,
Barry

 

[Barry Gilbert]

In the startup dialog (Tools, Startup), uncheck Display Database Window and

Show Built-in Menus. This will prevent users from seeing the database window
and from being able to use Window,Unhide to unhide the db window.

This should have read: "uncheck Display Database Window and Allow Full Menus"

Barry

 

[Matt]

This should have read: "uncheck Display Database Window and Allow Full Menus"

Barry

Barry,
That was a huge help!
Thanks for the notes, I actually locked myself out of the database
twice, so I would have been SCREWED.

I appreciate the help.