[Resolved] Hiding everything but Forms in MS Access

[deane034]

hey guys,

i have a system based on Ms Acess, what iwant to do is, when a user opens my database all he should be able to see is the forms, and not anything else. or better yet can i even hide the forms thing, and only present the user with forms that he needs to view?

can i do that in MS Access?

[kpaske]

I think it falls under tools->startup. You can select the form to load by default and all other forms and tables will be hidden. The only catch is that they can select window->unhide to view the rest of the DB, but I think you can also disable this by disabling full menus.

[RobDog888]

Another way to do it is to create your own menu and/or toolbar. Then place the menu items or buttons in them that you only want the users to be able to use. Then in the autoexec macro create it to turn off all menus and toolbars. Then create another menu or toolbar that will also display for your user name. This can be like an Admin version. and dont forget to give yourself a way to restore all the menus and toolbars for any new future development or debugging.

[deane034]

hey thanks... i tried that first method, of clearing evetything in startup

but now i can get back to normal view. the window > option is not there

so.. please can someone point the waY??!!

[deane034]

ok sorry guys.. got it.. u have to press shift while opening to bypass the start up options


thanks for the replies