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
    557

    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:	24 
Size:	36.3 KB 
ID:	43236
    Thanks, Paul

  2. #2
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    7,677
    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.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

  3. #3
    Paul H's Avatar
    Paul H is offline Expert
    Windows 10 Access 2016
    Join Date
    Sep 2011
    Location
    Richmond, VA
    Posts
    557
    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:	21 
Size:	23.5 KB 
ID:	43243

    XML from YouTube
    Click image for larger version. 

Name:	USysRibbons From YouTube.JPG 
Views:	21 
Size:	21.9 KB 
ID:	43244
    Thanks, Paul

  4. #4
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    2,484
    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:	20 
Size:	172.6 KB 
ID:	43245

  5. #5
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    4,416
    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 (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  6. #6
    Paul H's Avatar
    Paul H is offline Expert
    Windows 10 Access 2016
    Join Date
    Sep 2011
    Location
    Richmond, VA
    Posts
    557
    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 Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    4,416
    Excellent. Glad to be of help!
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

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 - Senior Forums