Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Security _ Hide Privacy Options

Posted by: Tabbycat1234 Sep 28 2012, 08:31 AM

I have a database, I know how to hide most everything. However when I open the program I can still go to File and the "Privacy Options" This can allow the user to change the setting if they just want to play around.
How can I hide the Privacy Options to make the database totally secure.

Posted by: Peter46 Sep 28 2012, 08:39 AM

Can you post an image.
don't have anything called 'Privacy Options' here.
Are you referring to Trust Centre settings?
If so, those are controlled by the Access user, not by the application developer.

Posted by: Tabbycat1234 Sep 28 2012, 08:47 AM

Here is the best picture I could come up with here at work.
You will find it if you go to File on the access menue after you open everything that has been hidden
When you want to unhide everything you open the program holding down the shift key

 

Posted by: Peter46 Sep 28 2012, 09:14 AM

I can't work out what that image is.
This is what I have on the File menu...

 

Posted by: Tabbycat1234 Sep 28 2012, 02:03 PM

Sorry I had to wait till I got home so I could get a better picture of the options that I am talking about.
need to hide the privacy options under file (see the picture)

 

Posted by: Peter46 Sep 30 2012, 03:02 AM

OK - I see now that you get that option if you hide everything else.
Odon't know whether it is possible to hide that option- I have asked for others to take a look.

Posted by: argeedblu Sep 30 2012, 04:34 AM

This thread has an apparent solution near the end of the thread
http://social.technet.microsoft.com/Forums/da/officeitpro/thread/0db3e246-04b6-4948-a98c-4459fb65b1f9
Glenn

Posted by: argeedblu Sep 30 2012, 06:42 AM

I tried the suggested solution in a new accdb and this is the result
attachment=55778:NoPrivacy.png]
Glenn

 

Posted by: Tabbycat1234 Sep 30 2012, 04:40 PM

Agrrblu I tried that solution but I don't totally understand it, can you tell me exactly what to do.
I have to get this figured out!

Posted by: argeedblu Sep 30 2012, 05:54 PM

Can you repeat what you have done in a new database, then zip and upload it. That will be easier for me to analyze than trying to guess where you may have gone wrong.
Glenn

Posted by: Tabbycat1234 Sep 30 2012, 06:04 PM

Here is a test database that is just like the original, I need to know how to do it. I cant send the original it is for my job and that cant be put out there

 PO_Database.zip ( 89.72K ): 125
 

Posted by: argeedblu Sep 30 2012, 08:19 PM

Test database is just fine, even preferred. I will have a look in the moorning.
Glenn

Posted by: argeedblu Oct 1 2012, 04:45 AM

Good Morning,

The text of the solution is:
After you create the table USysRibbons, close and reopen the database. Hold Shift down while you open it. Then go to File/Options and CurrentDatabase. Set the Ribbon to the name of the Ribbon you used in USysRibbons (SimpleFile).
I have made these modifications in your sample database and attached it
 RibbonDemo.zip ( 32.57K ): 179

Glenn

Posted by: Tabbycat1234 Oct 1 2012, 07:30 AM

I am sorry but I am a bit confused I don't see your USSystemsRibbions in you program. Is there somewhere else I should be looking or doing this.
Thanks for all your help

Posted by: argeedblu Oct 1 2012, 07:43 AM

Because the table name is begins with USys you have to go to your navigation options and turn on show system files
Glenn

Posted by: Tabbycat1234 Oct 1 2012, 08:07 AM

Here is what I have done. I have made screen shots to show you. I know it shouldn't be this hard
made the table like you said. (example1) I then went into options to choose the table and it is not in the drop down bar. (example 2)

 

Posted by: argeedblu Oct 1 2012, 08:25 AM

Did you close and re-open the database? What you should see is the ribbon name, not the file name. In the original code the Ribbon Name is SimpleFile.
Glenn

Posted by: Tabbycat1234 Oct 1 2012, 08:45 AM

Still not working. This is what I have for my table

 

Posted by: argeedblu Oct 1 2012, 09:03 AM

What data do you have in the USysRibbons table? Copy the data and paste in your post. It looks like there is a problem with the XML.

Posted by: Tabbycat1234 Oct 1 2012, 10:05 AM

This is what I have
lt;customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui"><ribbon startFromScratch="false"></ribbon><backstage><button idMso="ApplicationOptionsDialog" visible="false"/></backstage></customUI>

Posted by: argeedblu Oct 1 2012, 10:14 AM

I will need to look at the actual database. Can you upload one in which you have made the change please?
Glenn

Posted by: Tabbycat1234 Oct 1 2012, 10:17 AM

Here is the database. I will be out most of the day.
Thanks for your help

 PO_Database.zip ( 84.14K ): 39
 

Posted by: argeedblu Oct 1 2012, 10:29 AM

I downloaded, uzipped, and opened your database and it worked exactly as I expected. Re-open the database at your end and let me know whether or not there is still a problem.
Glenn

Posted by: Peter46 Oct 1 2012, 11:09 AM

Glenn, I've just downloaded the file and it shows Privacy Options for me.
I have no idea what I'm talking about here, but is it possible that this xml setting is in any way machine specific or user specific?
Peter

Posted by: argeedblu Oct 1 2012, 11:32 AM

Hi Peter,
It shouldn't be machine or user specific. Try opening it with the shift key down and then look at File/Options/Current Database/Ribbon
The setting should read SimpleFile.
When I downloaded and opened the file, Privacy Options button was not there.
Glenn

Posted by: Peter46 Oct 1 2012, 11:47 AM

No ribbon name showing. There's nothing in the dropdown.
Image attached.
I have the 'simplefile' record in usysribbons though.

 

Posted by: argeedblu Oct 1 2012, 11:57 AM

Very strange. Please zip and upload the file (even if that sounds redundant to you)
Glenn

Posted by: argeedblu Oct 1 2012, 12:13 PM

OK. I had another look. I must have inadvertently opened the wrong file earlier.
When I opened the correct file, this is what I found:
Both field names in USysRibbons are misspelled. There is an extra "i" after the second "b"
Change the names. Save the table design. Close the database. Reopen it.
Glenn

Posted by: Peter46 Oct 1 2012, 12:20 PM

That works once you have selected the simplefile ribbon in the Current Database options and done a close/open

Posted by: argeedblu Oct 1 2012, 12:28 PM

Yep. I should have added Select the Ribbon in Options then close and reopen the database again.
ccess apparently reads the USysRibbons table only when it starts. So you have to close the database once you have modified the table so that Access will re-read it.
Glenn

Posted by: Tabbycat1234 Oct 1 2012, 03:03 PM

It is still not working for me what the heck am I doing wrong?

Posted by: ScottGem Oct 1 2012, 03:19 PM

Did you correct the misspellings Glenn found?

Posted by: argeedblu Oct 1 2012, 03:20 PM

Did you check the field names in USysRibbons?
id you correct the spelling of the field names?
I did you save the table changes?
Did you close and reopen the database?
Were you then able to select the Ribbon?
Did you then close and reopen the database?
Glenn

Posted by: Tabbycat1234 Oct 1 2012, 03:23 PM

Yea that worked thank you so much

Posted by: argeedblu Oct 3 2012, 08:30 AM

You are very welcome Tabby Cat,
Glenn

Posted by: kcnewheart Sep 21 2018, 12:29 PM

I had this working for Access 2010 (same XML as indicated earlier by Tabbycat1234), but it's not working now (Access 2013). It won't hide "Privacy Settings". This is copied straight out of the USysRibbons table which has two fields, RibbonName="UserDefault" and RibbonXML which is defined as below:

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon startFromScratch="false"></ribbon>
<backstage>
<button idMso="ApplicationOptionsDialog" visible="false"/>
</backstage>
</customUI>

And yes, "UserDefault" was an available option to choose for Ribbon Name and I did select it and closed the database and reopened it.

What is available for selection in the File tab is: Print, Privacy Options, and Exit.

Please help!

Posted by: isladogs Sep 21 2018, 01:23 PM

This is what I have to only show the Exit command on the File menu
Almost identical to yours but not quite
It works in both 2010 & 2016 (365) - not tested in 2013 but I can't see that would matter

My ribbon is called also SimpleMenu like those earlier in this thread

CODE
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
  <ribbon startFromScratch="false">
       <!-- Ribbon XML -->
  </ribbon>
  <backstage>
   <tab idMso ="TabPrint" visible="false"/>
   <button idMso="ApplicationOptionsDialog" visible="false"/>
   <button idMso="FileExit" visible="true"/>
  </backstage>
</customUI>

Posted by: theDBguy Sep 21 2018, 01:33 PM

Hi knewheart,

Welcome to UtterAccess!
welcome2UA.gif

Have a look at http://thedbguy.blogspot.com/2018/05/backstage-view.html.

Hope it helps...

Posted by: munhun Oct 1 2018, 08:19 PM

Hello.

<button idMso="ApplicationOptionsDialog" visible="false"/>

... ApplicationOptionsDialog visibled.
But ....
I can open the options window by right clicking on the ribbon.

How do I hide this pop-up menu?

I would be grateful if you could email me at jeongmunhun@gmail.com.

Thank you.

 

Posted by: theDBguy Oct 1 2018, 09:16 PM

Hi,

Welcome to UtterAccess!
welcome2UA.gif

Which version of Access are you using? I can't read kanji(?), so I'm not sure I know which ones you're pointing at. Did you download the demo from my website? Here is a screenshot of what I got when I right-clicked on the ribbon area using the demo.


When you open my demo, do you get the same result as the above screenshot?

Posted by: munhun Oct 10 2018, 07:43 PM

The screenshots you showed are what I want.

The version I use is 2010.

Where is the demo?
I'd like you to display the link.


Thank you.

Posted by: theDBguy Oct 10 2018, 08:00 PM

Hi,

The link to my website is in my signature below. When you get there, click on the Demo tab.

Hope it helps...

Posted by: munhun Oct 10 2018, 08:51 PM

Thank you very much.

<ribbon startFromScratch="true">

This sentence solved what I wanted.

Thank you.

Posted by: theDBguy Oct 10 2018, 09:07 PM

You're welcome. Glad to hear you got it to work. Good luck with your project.

Posted by: dterrell625 Feb 13 2019, 07:33 PM

I tried the code that you showed to hide everything except for Exit. Nothing shows up when I go to select SimpleMenu as the Ribbon. I have attached it. Could you please tell me what I am doing wrong?

 SimpleMenu.zip ( 23.56K ): 10
 

Posted by: theDBguy Feb 13 2019, 07:58 PM

Hi. Welcome to UtterAccess!

welcome2UA.gif

Which version of Access are you using? Have you seen https://thedbguy.blogspot.com/2018/05/backstage-view.html?

Posted by: theDBguy Feb 13 2019, 08:32 PM

Hi. I just downloaded your file and where you went wrong is that you had the wrong table name and your Ribbon XML is incomplete. Try downloading the demo I had here or on my website to see what it's supposed to be. Also, take a look at the article link I posted earlier.

Posted by: dterrell625 Feb 13 2019, 09:15 PM

I just found the demo. It definitely hides the privacy options. I was thinking it was going to reduce it to exit and also hide the quick access toolbar,home tab, file tab and tell me what you what you want to do.

Posted by: theDBguy Feb 13 2019, 09:35 PM

Okay, let us know how it goes...

Posted by: dterrell625 Feb 13 2019, 09:47 PM

I can't figure it out. I have been trying every little way I can for the last week on this. I think I have got everything else to protect a database. I have the login and the audit trail. I think this is the last thing I need for security other than disabling the shift key. But I don't want to do that before I figure out how to get into the database myself. Which I will work on. I am not a programmer and this security stuff is really hard. I am able to create tables, queries, reports and forms like I want. But I need to get this security thing to hide everything before I can actually split the database for deployment.

Posted by: theDBguy Feb 13 2019, 09:52 PM

Can you post your actual database without any data, so we can tell you what's missing? Also, did you mention which version of Access you will be using to run your database application? As I mentioned in the previous article, the code to hide the backstage has changed from 2010 to 2016.

Posted by: dterrell625 Feb 13 2019, 10:05 PM

I have even put this in my actually database yet because I don't want to take the chance of doing anything to it. I am still building it. So I am just trying to do this on its own and then import it in.

 Database1.zip ( 22.43K ): 5
 

Posted by: dterrell625 Feb 13 2019, 10:06 PM

By the way I have access 2007 and 2016 on my computer. I am trying to do this in 2016.

Posted by: theDBguy Feb 13 2019, 10:15 PM

Okay, looking at the latest file you uploaded, I see you got the name of the table correct now; however, the XML for the ribbon is still incomplete. Why have you not tried simply copying the XML from my demo into your database and just replace the backstage section with the updated version from the blog article?

Posted by: theDBguy Feb 13 2019, 10:17 PM

Here's a copy of the file you just posted. All I did was select the ribbon as the system ribbon. Take a look at the File menu now.


 Database1.zip ( 18.02K ): 15
 

Posted by: dterrell625 Feb 13 2019, 10:32 PM

I tried to select that, but it wouldn't show up. I don't know why. But the quick access toolbar still shows. And is it possible to disable the file and the home button too?

Posted by: theDBguy Feb 13 2019, 10:35 PM

Hi. The Home, yes, the File, No.

Posted by: dterrell625 Feb 13 2019, 10:44 PM

How do I hide the Home button and the quick access toolbar?

Posted by: theDBguy Feb 13 2019, 10:54 PM

Hi. Using startFromScratch=true will hide the built-in ribbon, which includes the Home tab. Check out https://www.accessribbon.de/en/?Access_-_Ribbons:Ribbon_XML_Controls:QAT for hiding the QAT.

Posted by: dterrell625 Feb 13 2019, 10:55 PM

I will do that. Thank you.

Posted by: theDBguy Feb 13 2019, 10:59 PM

You're welcome. Have a good night.

Posted by: dterrell625 Feb 13 2019, 11:00 PM

That was exactly what I needed. Thank you so much. I apologize for seeming so dumb about this. But I really don't know anything about it. You are a lifesaver. I feel so much more secure about being able to deploy the front end when I get it all finished.

Posted by: theDBguy Feb 13 2019, 11:02 PM

You're welcome. Good luck with it.

Posted by: Ahmed82 Aug 22 2019, 06:02 AM

thanks so much
is there is any way to can add more secure for this demo like
notallow form/report/macro desine view for user

Posted by: jwild Aug 22 2019, 08:54 AM

Make an accde: File, Save and Publish, Make ACCDE

Posted by: Ahmed82 Aug 23 2019, 07:53 AM

thanks for replay

but in accde file
user still can
change design Query, table, macro
delete table,query,form,report,macro

as u see we still no minimum security