Commandbarscontrol and right mouse click 1

[JDRoss]

I have security concerns for a backend database. Though it requires user-level logon access, I would still need to disable Access menu items. I don't have any custom menu bars, but I would like to disable "Export" features and other database utilites from the curious. So far when I run this code it disables the "Menu Bar" menu:

Application.CommandBars("Menu Bar").Enabled = False

However, if I right click on a table I see that the "Export" control is still active.

What could be happening or how can I reference this Right-Click menu. Any advice?

John

 

[ZmrAbdulla]

Hi,
Open your Shorcut Menu bar

Tools > Customize > Shortcut Menu

Database > Table > then drag the commands that you don't want to the dialog. It will dissapear from the menu. You can even customize any other commands that you want.

Close the dialog and right click on the table !!

also make sure that it customized only in this database by opening another database.

Regards

Zameer Abdulla

http://www.geocities.com/zameerabd/

http://www.mtkhoory.com

 

[VBslammer]

I personally like to use custom menus for everything so I have control over what the user sees. It's easier to add the controls they need than to remove all the built-in stuff.



VBSlammer

Unemployed in Houston, Texas

 

[JDRoss]

Thanks Zameer and VBSlammer,

I will implement your suggestion Zameer for now but I am also interested in VBSlammer's approach, can you give me some idea how to go about creating custom menus? And is it possible to save these and have them for other databases as well?

John

 

[JDRoss]

Zameer

"...also make sure that it customized only in this database by opening another database."

I did the shortcut menu thing you suggested but I wasn't quite sure what the following meant "then drag the commands that you don't want to the dialog."

I right clicked the deleted the menus and now they are gone from all databases.

Any ideas to restore and start again?

John

 

[ZmrAbdulla]

Hi,
Have look on this article.

http://www.jamiessoftware.tk/articles/menubars.html

Regards

Zameer Abdulla

http://www.geocities.com/zameerabd/

http://www.mtkhoory.com

 

[JDRoss]

Thanks Zameer

Great article!

John