Removing the New Database and Open Database options from the OfficeButton

[evenlater]

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!

[ARC]

Under the office menu code, you should be able to hide it as follows:

<officeMenu>
<button idMso="FileOpen Database" visible="false"/>
</officeMenu>
Hope this helps,

Andy


"evenlater" <ev*******@gmai l.comwrote in message
news:65******** *************** ***********@i76 g2000hsf.google groups.com...

>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!

[evenlater]

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...@PCESof t.invalidwrote:

Under the office menu code, you should be able to hide it as follows:

<officeMenu>
<button idMso="FileOpen Database" visible="false"/>
</officeMenu>

Hope this helps,

Andy

[ARC]

It's right at the beginning:

<customUI xmlns="http://schemas.microso ft.com/office/2006/01/customui">
<ribbon startFromScratc h="true"<butt on idMso="FileOpen Database"
visible="false"/>
<officeMenu.... .......


"evenlater" <ev*******@gmai l.comwrote in message
news:74******** *************** ***********@k30 g2000hse.google groups.com...

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...@PCESof t.invalidwrote:

>Under the office menu code, you should be able to hide it as follows:

<officeMenu>
<button idMso="FileOpen Database" visible="false"/>
</officeMenu>

Hope this helps,

Andy

[evenlater]

I've added the code just below the "startFromScrat ch" 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.microso ft.com/office/2006/01/customui"
onLoad="OnRibbo nLoad" loadImage="Load Images">
<commands>
<command idMso="Help" enabled="true"/>
<command idMso="WindowCl ose" enabled="true"/>
<command idMso="WindowRe store" enabled="true"/>
<command idMso="WindowMi nimize" enabled="true"/>
</commands>
<ribbon startFromScratc h="true">
<officeMenu>
<button idMso="FileNewD atabase" visible="false"/>
<button idMso="FileOpen Database" visible="false/>
<splitButton idMso="FileSave AsMenuAccess" visible="false" />
</officeMenu>
<tabs>
<tab id="tab0" label="Home">
<group idMso="GroupWin dowAccess" >
</group>
</tab>
</tabs>
</ribbon>
</customUI>

[ARC]

Try changing to:

<customUI xmlns="http://schemas.microso ft.com/office/2006/01/customui"
onLoad="OnRibbo nLoad" <ribbon startFromScratc h="true">
<officeMenu>
<button idMso="FileNewD atabase" visible="false"/>
<button idMso="FileOpen Database" visible="false/>
<splitButton idMso="FileSave AsMenuAccess" visible="false" />
</officeMenu>
<tabs>
<tab id="tab0" label="Home">
<group idMso="GroupWin dowAccess" >
</group>
</tab>
</tabs>
</ribbon>
</customUI>

"evenlater" <ev*******@gmai l.comwrote in message
news:15******** *************** ***********@j22 g2000hsf.google groups.com...

I've added the code just below the "startFromScrat ch" 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.microso ft.com/office/2006/01/customui"
onLoad="OnRibbo nLoad" loadImage="Load Images">
<commands>
<command idMso="Help" enabled="true"/>
<command idMso="WindowCl ose" enabled="true"/>
<command idMso="WindowRe store" enabled="true"/>
<command idMso="WindowMi nimize" enabled="true"/>
</commands>
<ribbon startFromScratc h="true">
<officeMenu>
<button idMso="FileNewD atabase" visible="false"/>
<button idMso="FileOpen Database" visible="false/>
<splitButton idMso="FileSave AsMenuAccess" visible="false" />
</officeMenu>
<tabs>
<tab id="tab0" label="Home">
<group idMso="GroupWin dowAccess" >
</group>
</tab>
</tabs>
</ribbon>
</customUI>

[evenlater]

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

Try changing to:

<customUI xmlns="http://schemas.microso ft.com/office/2006/01/customui"
onLoad="OnRibbo nLoad" <ribbon startFromScratc h="true">
<officeMenu>
<button idMso="FileNewD atabase" visible="false"/>
<button idMso="FileOpen Database" visible="false/>
<splitButton idMso="FileSave AsMenuAccess" visible="false" />
</officeMenu>
<tabs>
<tab id="tab0" label="Home">
<group idMso="GroupWin dowAccess" >
</group>
</tab>
</tabs>
</ribbon>
</customUI>

"evenlater" <evanca...@gmai l.comwrote in message

news:15******** *************** ***********@j22 g2000hsf.google groups.com...

I've added the code just below the "startFromScrat ch" 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.microso ft.com/office/2006/01/customui"
onLoad="OnRibbo nLoad" loadImage="Load Images">
<commands>
<command idMso="Help" enabled="true"/>
<command idMso="WindowCl ose" enabled="true"/>
<command idMso="WindowRe store" enabled="true"/>
<command idMso="WindowMi nimize" enabled="true"/>
</commands>
<ribbon startFromScratc h="true">
<officeMenu>
<button idMso="FileNewD atabase" visible="false"/>
<button idMso="FileOpen Database" visible="false/>
<splitButton idMso="FileSave AsMenuAccess" visible="false" />
</officeMenu>
<tabs>
<tab id="tab0" label="Home">
<group idMso="GroupWin dowAccess" >
</group>
</tab>
</tabs>
</ribbon>
</customUI>

[ARC]

That usually happens if there's an error in the ribbon code. Make sure you
have, under the office button, access options, Advanced, "show add-in user
interface errors". With this checked, you will see if there are any error's
in your ribbon. If there's even one error, the ribbon will not show any of
your customizations.

In the list of save commands, I'm not seeing this one:
="FileSaveAsMen uAccess". You might want to get rid of that line entirely.

Andy
"evenlater" <ev*******@gmai l.comwrote in message
news:22******** *************** ***********@y21 g2000hsf.google groups.com...

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

>Try changing to:

<customUI xmlns="http://schemas.microso ft.com/office/2006/01/customui"
onLoad="OnRibb onLoad" <ribbon startFromScratc h="true">
<officeMenu>
<button idMso="FileNewD atabase" visible="false"/>
<button idMso="FileOpen Database" visible="false/>
<splitButton idMso="FileSave AsMenuAccess" visible="false" />
</officeMenu>
<tabs>
<tab id="tab0" label="Home">
<group idMso="GroupWin dowAccess" >
</group>
</tab>
</tabs>
</ribbon>
</customUI>

"evenlater" <evanca...@gmai l.comwrote in message

news:15******* *************** ************@j2 2g2000hsf.googl egroups.com...

I've added the code just below the "startFromScrat ch" 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.microso ft.com/office/2006/01/customui"
onLoad="OnRibbo nLoad" loadImage="Load Images">
<commands>
<command idMso="Help" enabled="true"/>
<command idMso="WindowCl ose" enabled="true"/>
<command idMso="WindowRe store" enabled="true"/>
<command idMso="WindowMi nimize" enabled="true"/>
</commands>
<ribbon startFromScratc h="true">
<officeMenu>
<button idMso="FileNewD atabase" visible="false"/>
<button idMso="FileOpen Database" visible="false/>
<splitButton idMso="FileSave AsMenuAccess" visible="false" />
</officeMenu>
<tabs>
<tab id="tab0" label="Home">
<group idMso="GroupWin dowAccess" >
</group>
</tab>
</tabs>
</ribbon>
</customUI>

[evenlater]

Found the typo. I was missing a quotation mark at the end of the word
false on one line:
<button idMso="FileOpen Database" visible="false/>

Now my next question is what the syntax is to lose the Bluetooth
button and the Recent Documents section?