Is it possible to prevent users accessing database objects via the navigation pane.

[anewuser]

Hi,

At the risk of repeating myself in other questions. I have a multi-user login screen which works using the following code:

Option Compare Database
Private Sub Login_Click()
UserName.SetFocus
If UserName = "Staff1" And Password = "Staff1" Then
MsgBox "Welcome"
DoCmd.Close
DoCmd.OpenForm "Staff1"
ElseIf UserName = "Staff2" And Password = "Staff2" Then
MsgBox "Welcome"
DoCmd.Close
DoCmd.OpenForm "Staff2"
ElseIf UserName = "Manager1" And Password = "Manager1" Then
MsgBox "Welcome, please exercise caution when changing query or table conditions", vbInformation, "CDSignatures"
DoCmd.Close
DoCmd.OpenForm "Manager1"
Else
MsgBox "Please re-enter Username and Password"
End If
End Sub

At the moment this form is little more than a gimmick as anyone entering the program can access all objects in the navigation pane with a single click WITHOUT logging in. Is there a way to prevent users accessing objects in the navigation pane without logging in? I also want prevent users accessing items that aren’t on the relevant forms e.g. the manager1 form gives the user access to all objects in the navigation pane whereas the staff1 and staff2 forms only allow access to different forms.

[zmbd]

It is prefered to put the question in the body of the post too.

A couple of ways to do this...
Some depend on which verision of Access you are using.

However, if you go into the current database options there are some things that you can uncheck and one of them is the show navigation pane. You can also disable use special keys thus a simple F11 wont work to unhide the pane. (and I trap these with an autokeys macro too)

There are few VBA commands that can be used too; however, these are dependent on the version.

[anewuser]

Thanks for your help. I am using access 2007. How do I go about disabling the special keys?

[NeoPa]

Look in the Startup option from the Options menu on older versions. I expect it's easy enough to find in newer versions but I'm still using 2003 predominantly.

[zmbd]

Yes, NeoPa is correct...
In V2010 you goto the file ribbon\options\current database: All of these are available there.
I'm sure it's something along the same lines in 2007... we skipped that version.