Entering unknown territory hope you will assist

[Dave14867]

Hello all,

I was watching a video on securing the Front End of a database and thought I would incorporate it into 1 of mine and ran into some problems. It involves creating a login screen which went good and I understand that (I Think) but where I have an issue is where XML is needed to disable the "Options" in Access. I tried the XML code in the example but it throws an error on line 1 column 63 and on line 7 column 11. The XML is given below.

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

I then took this out and thins seems to work OK again but I cannot get rid of the "Options" under "Privacy Settings"


The zipped Database is attached. The Bypass Key has been Enabled so you can hold the Shift key down when you open it. The "Developers" Name is Developer and the Password is also Developer to use on the Login Screen.

New Login-3a.zip

Thanks
Dave

[June7]

Everything you need to know about ribbons at https://www.accessribbon.de/en/

There is a semi-colon instead of colon in line 1. Missing schemas:

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">

Lines 4 and 5 should be a single line. Missing opening < :

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

[Dave14867]

June,

I tried to make the corrections you suggested and got the following errors.







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

Thanks for the XML Link, I'll look into it but right now I would just like to get to be able to disable the Options and get this to work.

Thanks

Dave

[June7]

You didn't use schemas in the url string.

[isladogs]

Hi Dave
Suggest you read my article on improving security in Access databases which covers how to create a modified ribbon to remove items such as Access options... and much else besides.
The article also includes an example app you can use to test out each step.
See http://www.mendipdatasystems.co.uk/i...y-2/4594571073

P.S. Try <ribbon startFromScratch="true">

[Dave14867]

I took the XML Code from the video and it was working in the example. I don't know XML at all, this is my first attempt at it.

June, I don't know what you mean by schemas in the url string, the first error is saying it doesn't like the ">" at the end of the line 1, the second is saying it doesn't like the ">" at the end of line 6.

Colin,
Thanks for the link, I have opened it and I am sure I will get a lot out of it, but for now I would just like to know what I have to modify in the XML in the database attached above so I can at least get it to work and not lock up due the the errors.

Thanks

Dave

[Dave14867]

Colin,

I took the XML from your website and it seemed to correct the issue, Thank You so much.

Now I have something else to look into to try to improve future works, Thanks for the assistance.

Dave

[June7]

Look at the url string I show in post 2. It has word schemas. Yours does not.

The string in Colin's example also has this.

[isladogs]

Hi Dave
Glad to see the code from my article solved the immediate problem.
However, applying one bit of security is, on its own, little more than a temporary stopgap as knowledgeable users will know other ways to get around that.
If you need to apply security, then I strongly recommend you do it properly...