Locking Down Frontend Database

[data808]

Found this code online to lock down everything in the ribbon I guess.

I have a few questions:
Where do I enter this code?
Whats the difference between the menu bar, ribbon, and the command bar?
I also have Access 2007. Would this code work for that?


Private Sub LockDown()
DoCmd.ShowToolbar "Ribbon", acToolbarNo
DoCmd.ShowToolbar "Menu Bar", acToolbarNo


Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = False
Next i
End Sub

Thanks

[June7]

Search forum: custom ribbon

Here is one https://www.accessforums.net/securit...bar-39781.html

And a site I found helpful http://www.accessribbon.de/en/

Bing: Access custom ribbon

And Microsoft info http://msdn.microsoft.com/en-us/libr...ffice.12).aspx

[data808]

Hey June7,

why is that microsoft did not have a more user friendly way of locking down and securing a database? Why does it seem like this whole process is so manual? Did microsoft not anticipate that people would want to lock and restrict features of access for their users? Makes no sense.

Also what do you think of this set up:

Change all my forms to Modal and Pop Up.
Disable the shift key on open.
Change the file extention to .accdr
Hide all tables, forms, queries, macros, modules, and navigation pane.
Uncheck all the short menus and lay out view.

Do you know if this is secure enough? I think I still need to get rid of the quick access toolbar and the ribbon because if the user right clicks on the border above the ribbon, they can click customize toolbar and get access to all the options to unhide everything and get access to the tables to delete records. Is that right?

[June7]

I guess 2003 had security features but they were dropped with 2007. Access was really meant to be a single user app.

I seldom use modal and popup. They are annoying when debugging.

I've never locked out the shift key and never set up password login.

Never used accde or accdr.

I do hide the navigation pane and disable the F11 toggle and disable short menus and use custom ribbon.

Security is not an issue with the databases I've developed. Nobody else touches my master development copy of the frontend because they just wouldn't and the folder is secured. Nobody else goes directly to the backend.

[data808]

When you say its annoying when debugging for modal and popup, do you mean that when the app crashes, you are not able to see the vba to correct the bug?

How does the F11 toggle work? I heard about it and was thinking of doing that as well. What exactly does the user lose access to if I disable the F11 toggle?

I've been told that no one would go that far as to try and sabotage the data base and that I may be going to deep into securing it. I guess I may just be paranoid. Most people don't even know about the shift key nor do they know about the accdr file extension so maybe what I have is enough. Plus like you said, I too have a master frontend development file so if the user screws up the front end file, I can just replace it.

[June7]

Yes, modal and popup get in the way.

F11 just expands and collapse the navigation pane.

[amerch92]

Found this code online to lock down everything in the ribbon I guess.

I have a few questions:
Where do I enter this code?
Whats the difference between the menu bar, ribbon, and the command bar?
I also have Access 2007. Would this code work for that?


Private Sub LockDown()
DoCmd.ShowToolbar "Ribbon", acToolbarNo
DoCmd.ShowToolbar "Menu Bar", acToolbarNo
Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = False
Next i
End Sub

Thanks

Go to whatever the opening form is and click "Design". In the "Event" tab click "On Load". Paste the code within the macro. (delete the Private Sub LockDown() and End Sub parts).