Keep users from going to design view

Hello All.

I would like some advice.
What is the best way to make an Access database design not accessible?
Like accessing tables, form design and etc.
Is it a good idea to make a MDE file? What other options do I have?

On more question should all users have their own front end?

Thanks a lot.
Simone Dupre

re: Keep users from going to design view

Yes, creating an MDE is a great way to prevent users from switching your
forms and reports into design view, and prevent them messing with the code.

To prevent them messing with the design, set the database's AllowByPassKey
and AllowSpecialKeys properties of the MDE file to False. Details at
support.microsoft.com in k.b. article 313915.

Other options include the full security, but that's generally overkill
unless you have particularly sensitive data.

Yes, each user should have their own copy of the front end. It can be in
their workspace on a server if necessary, but it will run faster and reduce
network traffic if the application is installed onto their local hard disk.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Simone" <oimone@hotmail.com> wrote in message
news:fca7e30a.0312050546.2442cb85@posting.google.c om...[color=blue]
>
> I would like some advice.
> What is the best way to make an Access database design not accessible?
> Like accessing tables, form design and etc.
> Is it a good idea to make a MDE file? What other options do I have?
>
> On more question should all users have their own front end?
>
> Thanks a lot.
> Simone Dupre[/color]

re: Keep users from going to design view

"Simone" <oimone@hotmail.com> wrote in message
news:fca7e30a.0312050546.2442cb85@posting.google.c om...[color=blue]
> Hello All.
>
> I would like some advice.
> What is the best way to make an Access database design not accessible?
> Like accessing tables, form design and etc.
> Is it a good idea to make a MDE file? What other options do I have?[/color]

An .mde is best - for the front end. You can also laboriously use Access
security and set the permissions for each and every object so no one but you
can access design views.

On the back end, you actually might want to do something with permissions,
or set a database password.

[color=blue]
> On more question should all users have their own front end?[/color]

Yes.


[color=blue]
> Thanks a lot.
> Simone Dupre[/color]

re: Keep users from going to design view

I use this most of the time. Create a "Welcome" form with no objects and add
this code to form_load.





*****CODE*****

Private Sub Form_Load()

Dim MyDB As Database
Set MyDB = CurrentDb
If UCase$(CurrentUser) = "ME" Or UCase$(CurrentUser) = "THEM" Then
MyDB.Properties("StartupShowDBWindow") = True
MyDB.Properties("StartupShowStatusBar") = True
MyDB.Properties("AllowBuiltinToolBars") = True
MyDB.Properties("StartupShowDBWindow") = True
MyDB.Properties("AllowFullMenus") = True
MyDB.Properties("AllowBreakIntoCode") = True
MyDB.Properties("AllowSpecialKeys") = True
DoCmd.Close acForm, "frmwelcome"
Exit Sub
End If

MyDB.Properties("StartupShowDBWindow") = False
MyDB.Properties("StartupShowStatusBar") = False
MyDB.Properties("AllowBuiltinToolBars") = False
MyDB.Properties("StartupShowDBWindow") = False
MyDB.Properties("AllowFullMenus") = False
MyDB.Properties("AllowBreakIntoCode") = False
MyDB.Properties("AllowSpecialKeys") = False
MsgBox ("You are an invalid user!!")
Quit
End Sub

re: Keep users from going to design view

Thanks for all your responses.

There is one more thing, even if I make an MDE the user can go into
the table and enter records. I hide the database window but let's say
some user that knows a little too much like the shortcut F11 he or she
will be able to go into the tables and enter data.
I don't want them doing that since there is a complex relationship and
they must use the forms.

Thanks
Simone

"None" <None@none.com> wrote in message news:<0qqdnYHWPKdAvkyi4p2dnA@dls.net>...[color=blue]
> I use this most of the time. Create a "Welcome" form with no objects and add
> this code to form_load.
>
>
>
>
>
> *****CODE*****
>
> Private Sub Form_Load()
>
> Dim MyDB As Database
> Set MyDB = CurrentDb
> If UCase$(CurrentUser) = "ME" Or UCase$(CurrentUser) = "THEM" Then
> MyDB.Properties("StartupShowDBWindow") = True
> MyDB.Properties("StartupShowStatusBar") = True
> MyDB.Properties("AllowBuiltinToolBars") = True
> MyDB.Properties("StartupShowDBWindow") = True
> MyDB.Properties("AllowFullMenus") = True
> MyDB.Properties("AllowBreakIntoCode") = True
> MyDB.Properties("AllowSpecialKeys") = True
> DoCmd.Close acForm, "frmwelcome"
> Exit Sub
> End If
>
> MyDB.Properties("StartupShowDBWindow") = False
> MyDB.Properties("StartupShowStatusBar") = False
> MyDB.Properties("AllowBuiltinToolBars") = False
> MyDB.Properties("StartupShowDBWindow") = False
> MyDB.Properties("AllowFullMenus") = False
> MyDB.Properties("AllowBreakIntoCode") = False
> MyDB.Properties("AllowSpecialKeys") = False
> MsgBox ("You are an invalid user!!")
> Quit
> End Sub[/color]

re: Keep users from going to design view

Simone,

Before you create your .mde, go into the Advanced options under Tools |
Startup and uncheck the Access Special Keys option, or do something like
what None does below with the AllowSpecialKeys property.



"Simone" <oimone@hotmail.com> wrote in message
news:fca7e30a.0312081257.48f6401d@posting.google.c om...[color=blue]
> Thanks for all your responses.
>
> There is one more thing, even if I make an MDE the user can go into
> the table and enter records. I hide the database window but let's say
> some user that knows a little too much like the shortcut F11 he or she
> will be able to go into the tables and enter data.
> I don't want them doing that since there is a complex relationship and
> they must use the forms.
>
> Thanks
> Simone
>
> "None" <None@none.com> wrote in message[/color]
news:<0qqdnYHWPKdAvkyi4p2dnA@dls.net>...[color=blue][color=green]
> > I use this most of the time. Create a "Welcome" form with no objects and[/color][/color]
add[color=blue][color=green]
> > this code to form_load.
> >
> >
> >
> >
> >
> > *****CODE*****
> >
> > Private Sub Form_Load()
> >
> > Dim MyDB As Database
> > Set MyDB = CurrentDb
> > If UCase$(CurrentUser) = "ME" Or UCase$(CurrentUser) = "THEM" Then
> > MyDB.Properties("StartupShowDBWindow") = True
> > MyDB.Properties("StartupShowStatusBar") = True
> > MyDB.Properties("AllowBuiltinToolBars") = True
> > MyDB.Properties("StartupShowDBWindow") = True
> > MyDB.Properties("AllowFullMenus") = True
> > MyDB.Properties("AllowBreakIntoCode") = True
> > MyDB.Properties("AllowSpecialKeys") = True
> > DoCmd.Close acForm, "frmwelcome"
> > Exit Sub
> > End If
> >
> > MyDB.Properties("StartupShowDBWindow") = False
> > MyDB.Properties("StartupShowStatusBar") = False
> > MyDB.Properties("AllowBuiltinToolBars") = False
> > MyDB.Properties("StartupShowDBWindow") = False
> > MyDB.Properties("AllowFullMenus") = False
> > MyDB.Properties("AllowBreakIntoCode") = False
> > MyDB.Properties("AllowSpecialKeys") = False
> > MsgBox ("You are an invalid user!!")
> > Quit
> > End Sub[/color][/color]