Marshall Brooks
Member
- Local time
- Today, 16:57
- Joined
- Feb 28, 2023
- Messages
- 696
I think my database is fairly secure now, and I have an idea how I want to proceed but I thought I should "Ask the Experts" also.
The issue:
The issue:
- If a user presses F11, they can open the Visual Basic Editor. If they have access to the full .accdb version of my database (they don't), they could bypass most of my security fixes.
- This can be disabled under File Options - Enable Special Keys and re-opening the database:
-
- There is a VBA option to check/uncheck the Special Keys file option, but you still have to close and re-open the database.
- Leave the option off - which I am currently doing. But this creates a double (human) memory issue:
- First, typically I will need to debug something, and my breakpoints won't work. I'll do a Google search which leads me here or here:
- And then once I enable them so my breakpoint work, I have to remember to disable them before I distribute the database or I might as well leave them enabled.
- I was considering (and still somewhat am considering enabling the option (but I didn't originally realize the navigation pane was affected also):
- I distribute an .accde. I don't think most of our users would know that F11 opens the visual basic editor. If they do, they would know all my module names (no real help there), and then if they tried to see anything, they would see "Project is not viewable." No harm/no foul.
- Nav pane is a BIT more concerning, but they would have to be really determined - plus the new switchboard is more convenient for them to use. Risk here is if they REALLY know what they were doing, they could go to Navigation Options, turn on show hidden items, find the hidden data tables and delete some records - but again, they have to know a fair amount to figure that out.
- It would be somewhat possible to automate this -
Toggle Navigation Tabs On/Off in VBA
I have a A2007 application that I have developed in A2003 If I design a form in 2007 and have the Form Navigation tabs flag unchecked I cannot find a way to close a saved form. However if I turn them on I can. The issue is I don't want to have to do this prior to opening the app. Is there a way...www.access-programmers.co.ukAllowSpecialKeys Property [Access 2003 VBA Language Reference]
learn.microsoft.com- I have a Dev Mode/User Mode button on my switchboard (only for me). If I enable Dev Mode, It changes the setting and prompts me to re-boot. Then I have to click Dev Mode again and not reboot. When I click User Mode, it disables the setting.
Better Method: - This is complicated, but I could create a TempVars https://www.devhut.net/access-tempvars/ for DevMode. If I click the DevMode button, it sets the TempVar to True and enable the property. https://btabdevelopment.com/free-access-tools/ - Front end manager has an option to close the database and download a new version and re-open it. I could modify this to just close and re-open the current database. Then disable the property, and set the tempVar to false when I re-open the database.
- I have a Dev Mode/User Mode button on my switchboard (only for me). If I enable Dev Mode, It changes the setting and prompts me to re-boot. Then I have to click Dev Mode again and not reboot. When I click User Mode, it disables the setting.