Results 1 to 7 of 7
  1. #1
    Paul H's Avatar
    Paul H is offline Expert
    Windows 10 Access 2016
    Join Date
    Sep 2011
    Location
    Richmond, VA
    Posts
    591

    How to hide Privacy Options

    First off, I have already disabled Allow Full Menus. I have also disallowed Layout View. I have compiled and created an ACCDE version, but the File menu is still showing Privacy Options, which makes all the database options, including Show Navigation Pane, available to the user. I have seen some solutions involving XML, but it seems to me that Privacy Options should be hidden by default. I've got one other issue, but I'd rather knock these out one at a time.

    Your thoughts?



    Click image for larger version. 

Name:	Privacy Options.JPG 
Views:	35 
Size:	36.3 KB 
ID:	43236

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Everything I've ever seen or read on this says you need to modify the xml for the ribbon.
    Hiding all that stuff turns on Privacy Options, which is probably one of the more stupid things I've ever encountered in Access. Well, maybe there's a good reason for it, but it escapes me at present.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    Paul H's Avatar
    Paul H is offline Expert
    Windows 10 Access 2016
    Join Date
    Sep 2011
    Location
    Richmond, VA
    Posts
    591
    Thanks Micron, I agree. I'm following this video, https://www.youtube.com/watch?v=i1n7H686bWI , which seems pretty straightforward, but my first attempt failed. Multiple other attempts have failed. Here is my XML which I copied from the video. Either there is a typo I haven't found or this does not work on my version of Access.

    My XML
    Click image for larger version. 

Name:	USysRibbons.JPG 
Views:	32 
Size:	23.5 KB 
ID:	43243

    XML from YouTube
    Click image for larger version. 

Name:	USysRibbons From YouTube.JPG 
Views:	32 
Size:	21.9 KB 
ID:	43244

  4. #4
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    If you go to 7:28 in the video, you will see that below line is missing from your code...
    Click image for larger version. 

Name:	xmlRib.png 
Views:	32 
Size:	172.6 KB 
ID:	43245

  5. #5
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Change the USysRibbons XML to this:

    Code:
    <customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">  
      <ribbon startFromScratch="true">
       </ribbon>
       <backstage>
          <button idMso="ApplicationOptionsDialog" visible="false"/>
       </backstage>
     </customUI>
    Notice that I use StartFromScratch=True

    Or to remove all items from Backstage view (File menu), use:

    Code:
    <customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">    
        <ribbon startFromScratch="true">
          <tabs>
               <tab idMso="TabHomeAccess" visible="false" />
          </tabs>
        </ribbon>
        <backstage>
            <tab idMso ="TabPrint" visible="false"/>
           <button idMso="ApplicationOptionsDialog" visible="false"/>
           <button idMso="FileExit" visible="false"/>
           <tab idMso="TabOfficeFeedback" visible="false"/>
       </backstage>
     </customUI>
    For more info on this and other related security features, see: http://www.mendipdatasystems.co.uk/i...y-2/4594571073
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  6. #6
    Paul H's Avatar
    Paul H is offline Expert
    Windows 10 Access 2016
    Join Date
    Sep 2011
    Location
    Richmond, VA
    Posts
    591
    Thank you for both the solution and the Copy and Paste ability. I must have stopped the video at the wrong point.

    So glad to get this solved.

    Thanks again,

    Paul

  7. #7
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Excellent. Glad to be of help!
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 08-10-2018, 12:08 AM
  2. Replies: 1
    Last Post: 12-04-2014, 01:28 PM
  3. How to hide Access Options button?
    By ezz in forum Access
    Replies: 3
    Last Post: 11-24-2014, 11:58 AM
  4. privacy options
    By slimjen in forum Forms
    Replies: 1
    Last Post: 03-22-2013, 12:12 PM
  5. help please. i need basic access privacy/protection ideas
    By helpporfavorplz in forum Security
    Replies: 1
    Last Post: 02-20-2010, 05:32 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums