hide menu

[darkwraith]

Is there any way to hide, when I open my mde file, the Modify, Insert and Record menu in the toolbar?
I have some forms linked to various tables in my database and I don't want people to cancel records or to insert new records through the access menu bar.
I wish to find a way to let them visible only if you open the mde file by shif button, but I couldn't find how.
Thanks in advance,
Elena

 

[Jedi420]

Yes, there is. In your .mdb file (since you cant change a mde once its made), go to Tools -> Startup ... I believe it's the 'Allow Full Menus' CheckBox that you want to uncheck and maybe also the 'Allow Built-in toolbars' and 'Allow Toolbar/Menu Changes' checkboxes as well. It's possible to strip your users of virtually every priveledge without even using security. Let me know if that was the solution you were lookin for.

-Jedi420

A man who has risked his life knows that careers are worthless, and a man who will not risk his career has a worthless life.

 

[jason246day]

Hello there, I tried that, and now I would like to put them back, yet it took the toolbar off that allowed me to reenable it. Is there a way to get these back?

 

[Jedi420]

When you open your .mdb file ... hold the shift key down ... You'll then be able to get back in and make changes.

-Jedi420

A man who has risked his life knows that careers are worthless, and a man who will not risk his career has a worthless life.

 

[jason246day]

That didn't work, tools was not listed as one of the choices. Is there someway to reset it back to the default starup options.

 

[jason246day]

nevermind, I got it to work. thanks

 

[Jedi420]

When you hold shift .... hold it until everything is loaded. That should work ... if not ... we'll find a way to get it back, but I'm certain that holding shift gives you your ability to see 'Tools' in the menu back.

-Jedi420

A man who has risked his life knows that careers are worthless, and a man who will not risk his career has a worthless life.

 

[darkwraith]

Hi Jedi, I unchecked all the checkboxes in the startup mask but some menues still remain: 'File', 'Modify', 'Insert', 'Record', 'Window', '?'.
I begin to think there is no chance to eliminate them or at least some of them...
Elena

 

[Jedi420]

Here's what mine look like

If you look in each of those menus, you'll realize that most of the options are grayed out. I've effectively enabled security on my DB without actually setting up security ... except for a little flaw where people can still get past a disabled shift key, you can't do anything I don't want you too. Although, someone serious enough can get into just about anything if they try hard enough. (Sorry the pictures so big .. i was trying to respond quickly). Hope this helps (^_^)


-Jedi420

A man who has risked his life knows that careers are worthless, and a man who will not risk his career has a worthless life.

 

[darkwraith]

Hi Jedi, mine is the same, but unfortunately the menus are greyed out only if I open a mask that is not associated to a table.
When I open a form that loads data from one of the tables in my db, there are some items that become clickable, like 'Delete record', 'New record', etc...
I fear I should change the connection between the form and the table so not to load all the records.
Elena

 

[Jedi420]

Just a tip: You could actually implement true security on your DB which would make it impossible for users to delete and do all kinds of other nasty things without explicit permission.

-Jedi429

A man who has risked his life knows that careers are worthless, and a man who will not risk his career has a worthless life.

 

[luceze]

You can use code to enable and disable certain all or just a few menu items. If you are interested post back.

Eric

 

[Etherington]

If you want a quick and dirty solution, then create 2 new macros:

MenuBar (1st Macro Name)

Macro Name Action
&File AddMenu
Action Arguments
Menu Name &File
Menu Macro Name MenuBar_File

MenuBar_File (2nd Macro Name)

Macro Name Action
Exit RunCommand
Action Arguments
Command Exit

Then, on the forms that you want to display this limited menu, open the "Properties" for the form and under the "Other" tab, update Menubar to read MenuBar.

It's adaptable to use different pull down menu options on different forms if you want different options (I use one for Reports with the printer options also).

Hope this helps.