Avatar billede kroning Nybegynder
24. april 2016 - 23:36 Der er 13 kommentarer og
1 løsning

Sikre front end

Er det muligt at sikre sin front end 100% således at brugeren ikke har adgang til andet end formen.

Jeg har fjernet alle bånd undtagen Hjem
Jeg har fjernet Indstillinger i Filer menuen
Og jeg har fjernet muligheden for at trykke på shift ved åbning

Men brugeren kan stadig komme ind i indstillinger ved blot at højre klikke på Hjem båndet og vælge Tilpas båndet.
Så hvordan fjerner jeg denne højre kliks mulighed på Hjem båndet?
Avatar billede terry Ekspert
25. april 2016 - 10:04 #1
Heres a link which explains Access security, although I'm not sure its answers your question.

https://support.office.com/en-us/article/Introduction-to-Access-2010-security-cae6d764-0318-4622-955f-68d9f186d6ca
Avatar billede kroning Nybegynder
25. april 2016 - 10:24 #2
No, it did not.
Avatar billede fdata Forsker
25. april 2016 - 10:38 #3
Gen din base som en .accde fil. Så er al design og kode beskyttet.
Avatar billede terry Ekspert
25. april 2016 - 11:13 #4
but not your table design
Avatar billede kroning Nybegynder
25. april 2016 - 12:52 #5
Selv om jeg gemmer som accde fil så kan en nysgerrig bruger stadig komme ind og rode direkte i tabellerne pga. den højre kliks mulighed som jeg gerne vil have fjernet.
Avatar billede terry Ekspert
25. april 2016 - 13:51 #6
There are a few videos on YT which I think can help you.

https://www.youtube.com/watch?v=be1JPnQr8v8
Avatar billede terry Ekspert
25. april 2016 - 14:03 #7
Avatar billede kroning Nybegynder
25. april 2016 - 17:41 #8
I have seen both videos but none of them shows how to disable the right click menu on the ribbon.
Avatar billede terry Ekspert
26. april 2016 - 09:05 #9
I'm sure that the second video does that.

Just disabling right click isn't going to make your database tamper proof. If you can enable it again then your users can too, so you have to do more than just disable the right click to stop users tampering, but at the same time allowing you or other developers to enable it again.

Making your database secure isn't an easy (one click) process, there are a number of things you have to consider. Such as having different permissions for different users. So I'd suggest you maybe look at another video from same guy first.

https://www.youtube.com/watch?v=DxRpo496w_c
Avatar billede kroning Nybegynder
26. april 2016 - 11:18 #10
I have seen all of Steve Bishops 79 videos, about 19 hours :-), and I have done all that he describes in his videos.
I may have found a solution, if you set startFromScratch="true" in the USysRibbons table and then build your own custom ribbons then the right click option one the ribbons is no longer available. So I am working on that right now.
Avatar billede terry Ekspert
26. april 2016 - 11:26 #11
"and I have done all that he describes in his videos."

and didn't that give you what you wanted, IE Stop users using right clicking to get to settings etc?
Avatar billede kroning Nybegynder
26. april 2016 - 12:06 #12
Yes the user cant right click on the forms, but the problem is that they can right click on a ribbon, like the HOME or PRINT ribbon, and then from there get into settings and change whatever the want.
Avatar billede terry Ekspert
26. april 2016 - 12:19 #13
I must have watched another video then, was sure right click was disabed stopping user getting into settings
Avatar billede kroning Nybegynder
27. april 2016 - 00:27 #14
Problemet blev løst ved at lave nogle custom ribbons.
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Dyk ned i databasernes verden på et af vores praksisnære Access-kurser

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester