Share via

Database Lockdown

Anonymous
2016-08-19T00:25:24+00:00

I am trying to lock down a portfolio database so people can't access the ribbons, menus, VBA Editor, etc. unless I give them permissions. I have disabled the Shift key at start up to skip the Autoexec macro. I have the menus and ribbons not visible. I had anything using F11 disabled (Ctrl, Shift, Alt) as some of them gave people permissions I did not want them to have. Then I was reading a text book and found out that Ctrl G also gives access to the VBA Editor. I have disabled that now. I suppose the question is, are there any other key combinations etc. that I need to worry about? I want people to try it out as users, nothing more. I can use another back door to revert to development mode. In a truly professional piece, I would probably just keep a separate version with relaxed security for development.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

ScottGem 68,830 Reputation points Volunteer Moderator
2016-08-19T23:03:38+00:00

Did you try Compiling the database first? It could be that there are syntax errors in your VBA that need to be cleared up.

PS. to Tom, Ahh I see.

Was this answer helpful?

0 comments

13 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
    2016-08-19T05:15:08+00:00

    The Home edition is not licensed for the kind of usage you seem to be describing here. Read the EULA.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-08-19T02:43:30+00:00

    Thanks for the link. I will have to take a look at that.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-08-19T02:41:57+00:00

    I may be mistaken, but I don't think the home version of Access has that ability. I think I would need to get the developers version, which is a little pricy when you are between jobs.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2016-08-19T00:40:10+00:00

    Alt+F11 -> Open VBE

    F11 -> Show/Hide Navigation Pane

    Although dated, it is still relevant: https://msdn.microsoft.com/en-us/library/office/aa200349(v=office.11).aspx

    But why not compile as accde and distribute that?

    Was this answer helpful?

    0 comments