MDE File

M

Muriukis

Thanks Doug and Arvin I succeeded in making the MDE File and its working well
but now I don't want the users to see all access the tables.I have a main
form with controls for opening the respective forms and reports but the user
can access my tables what can I do . Am new to access but since I joined the
forum my understanding has improved any help Guys
 
J

Joan Wild

There's a lot you can do to lock down the frontend...

Create custom menus/toolbars for use throughout your application.
Use the features in Tools, Startup to
set your main form as the startup form
set your default menu (the custom one you made)
disable all the checkboxes about allowing built in menus, toolbars, changes etc.
hide the db window (ensure the custom menu you create does not include the Windows, Unhide item)
uncheck allow special keys (this will disable the F11 key, among others)

If you need to bypass these startup features, you can hold the shift key down while you open the db. If you feel that your users may use this to bypass your settings, you can disable the shift key bypass - there's an example in help for doing this(look for AllowBypassKey) or at
http://www.mvps.org/access/modules/mdl0011.htm
 
Top