How lock users out of the tables, queries, reports, etc.

Is there a way to lock users out of the objects in the navigation pane?  I thought that by splitting the database and saving the front-end file as an accdb file this would work but I guess it doesn't.

Any tips?
SteveL13Asked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<1)  How do I turn off the database container and menus.  >>

 Start up options:   File, Options, current database, Un-check "Display Navigation Pane".

The menus are not available in the runtime version.

<<2) How do I force it into runtime mode by adding code at startup that quits if the app is not running that way.>>

If SysCmd(acSysCmdRuntime) = False then Application.Quit

Or

If SysCmd(acSysCmdRuntime) = False then
  MsgBox "This application can only be executed in runtime mode", vbOKOnly+vbCritical
  Application.Quit
End If

 If you want to message the user.

Jim.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
A bound and determined can get at things, but you can make it very difficult.  First your app should always be split, even if it's single user.

 Then distribute the "front end" as a MDE/ACCDE and turn off the database container and menus.  Force it into runtime mode by adding code at startup that quits if the app is not running that way.  

 That locks them out of all the design features, and because it is a MDE/ACCDE, they can't get at to code either.

Jim.
0
 
SteveL13Author Commented:
Jim.  Ok.  But questions:

1)  How do I turn off the database container and menus.  

and,

2) How do I force it into runtime mode by adding code at startup that quits if the app is not running that way.

--Steve
0
 
PatHartmanCommented:
If your users are not sophisticated, simply renaming the FE from .accde to .accdr will prevent them from entering design mode on anything.

PS  - Be very careful when using  an .mde/.accde that you retain the original .accdb in a safe place.  There is no easy way to recover the .accdb from an .accde.  There are services but you won't necessarily like what you get.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.