Removing the New Database and Open Database options from the OfficeButton

>I have an .accde file with custom ribbons and with "Allow Full Menus"
set to False, but the Office Button menu still gives the user the
ability to create a new Access database, or -- much worse -- open an
existing one.
>
My application is on a terminal server and I'm trying to plug all the
holes so the user can't do anything but use my application. But right
now if the user goes to the Office Button and clicks "Open", he can
navigate to the back-end of my application and use/change/delete the
tables. Even if I use Access User Level Security (and I am), since the
user is logged into the MDW file, he can do anything I've given him
permission to do -- add records, delete records, etc. -- without any
of the data validation, date stamping and logging I've programmed into
my forms.
>
Help!

Under the office menu code, you should be able to hide it as follows:
>
<officeMenu>
<button idMso="FileOpenDatabase" visible="false"/>
</officeMenu>
>
Hope this helps,
>
Andy

That does help, but where do you put that code? In the ribbon XML? And
if so, at what point?
Thanks!
>
On Jul 2, 10:44 am, "ARC" <PCES...@PCESoft.invalidwrote:

Quote: >Under the office menu code, you should be able to hide it as follows: >> ><officeMenu> ><button idMso="FileOpenDatabase" visible="false"/> ></officeMenu> >> >Hope this helps, >> >Andy

>
>
>

I've added the code just below the "startFromScratch" line, but it's
still not working. I'm not sure if the fact that I wrote the original
ribbon code with the IDBE Ribbon Creator is part of the problem.
Here's what I've got... can you see what I'm missing here?
>
<!-- Created with IDBE Ribbon Creator (Version: 1.1017) -->
<!-- http://www.RibbonCreator.com -->
<!-- http://www.RibbonCreator.de -->
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"
onLoad="OnRibbonLoad" loadImage="LoadImages">
<commands>
<command idMso="Help" enabled="true"/>
<command idMso="WindowClose" enabled="true"/>
<command idMso="WindowRestore" enabled="true"/>
<command idMso="WindowMinimize" enabled="true"/>
</commands>
<ribbon startFromScratch="true">
<officeMenu>
<button idMso="FileNewDatabase" visible="false"/>
<button idMso="FileOpenDatabase" visible="false/>
<splitButton idMso="FileSaveAsMenuAccess" visible="false" />
</officeMenu>
<tabs>
<tab id="tab0" label="Home">
<group idMso="GroupWindowAccess" >
</group>
</tab>
</tabs>
</ribbon>
</customUI>

Try changing to:
>
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"
onLoad="OnRibbonLoad" <ribbon startFromScratch="true">
<officeMenu>
<button idMso="FileNewDatabase" visible="false"/>
<button idMso="FileOpenDatabase" visible="false/>
<splitButton idMso="FileSaveAsMenuAccess" visible="false" />
</officeMenu>
<tabs>
<tab id="tab0" label="Home">
<group idMso="GroupWindowAccess" >
</group>
</tab>
</tabs>
</ribbon>
</customUI>
>
"evenlater" <evanca...@gmail.comwrote in message
>
news:1576d9c6-a39f-4181-b550-5770e6a13644@j22g2000hsf.googlegroups.com...
>

Quote: I've added the code just below the "startFromScratch" line, but it's still not working. I'm not sure if the fact that I wrote the original ribbon code with the IDBE Ribbon Creator is part of the problem. Here's what I've got... can you see what I'm missing here?

>

Quote: <!-- Created with IDBE Ribbon Creator (Version: 1.1017) --> <!-- http://www.RibbonCreator.com --> <!-- http://www.RibbonCreator.de --> <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" onLoad="OnRibbonLoad" loadImage="LoadImages"> <commands> <command idMso="Help" enabled="true"/> <command idMso="WindowClose" enabled="true"/> <command idMso="WindowRestore" enabled="true"/> <command idMso="WindowMinimize" enabled="true"/> </commands> <ribbon startFromScratch="true"> <officeMenu> <button idMso="FileNewDatabase" visible="false"/> <button idMso="FileOpenDatabase" visible="false/> <splitButton idMso="FileSaveAsMenuAccess" visible="false" /> </officeMenu> <tabs> <tab id="tab0" label="Home"> <group idMso="GroupWindowAccess" > </group> </tab> </tabs> </ribbon> </customUI>

Thanks, but it's still not working. I get the default ribbons/office
button menu.
>
>
On Jul 2, 6:03 pm, "ARC" <PCES...@PCESoft.invalidwrote:

Quote: >Try changing to: >> ><customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" >onLoad="OnRibbonLoad" <ribbon startFromScratch="true"> > <officeMenu> ><button idMso="FileNewDatabase" visible="false"/> ><button idMso="FileOpenDatabase" visible="false/> ><splitButton idMso="FileSaveAsMenuAccess" visible="false" /> > </officeMenu> > <tabs> > <tab id="tab0" label="Home"> > <group idMso="GroupWindowAccess" > > </group> > </tab> > </tabs> > </ribbon> ></customUI> >> >"evenlater" <evanca...@gmail.comwrote in message >> >news:1576d9c6-a39f-4181-b550-5770e6a13644@j22g2000hsf.googlegroups.com... >> Quote: I've added the code just below the "startFromScratch" line, but it's still not working. I'm not sure if the fact that I wrote the original ribbon code with the IDBE Ribbon Creator is part of the problem. Here's what I've got... can you see what I'm missing here? >> Quote: <!-- Created with IDBE Ribbon Creator (Version: 1.1017) --> <!-- http://www.RibbonCreator.com --> <!-- http://www.RibbonCreator.de --> <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" onLoad="OnRibbonLoad" loadImage="LoadImages"> <commands> <command idMso="Help" enabled="true"/> <command idMso="WindowClose" enabled="true"/> <command idMso="WindowRestore" enabled="true"/> <command idMso="WindowMinimize" enabled="true"/> </commands> <ribbon startFromScratch="true"> <officeMenu> <button idMso="FileNewDatabase" visible="false"/> <button idMso="FileOpenDatabase" visible="false/> <splitButton idMso="FileSaveAsMenuAccess" visible="false" /> </officeMenu> <tabs> <tab id="tab0" label="Home"> <group idMso="GroupWindowAccess" > </group> </tab> </tabs> </ribbon> </customUI>

>