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-19T20:17:12+00:00

    @Scott: there is indeed no separate Home version of the product, so Save As ACCDE is available. However, the Home editions are licensed differently and cannot be used for business activities. The techrepublic article fails to clarify this, and also leaves the incorrect impression that 5 people in a business can share one Home license. That's why I recommend reading the EULA.

    Was this answer helpful?

    0 comments
  2. ScottGem 68,830 Reputation points Volunteer Moderator
    2016-08-19T15:07:38+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.

    There is no "home" version of Access as far as I'm aware (but the new Office 365 versions are confusing). Access is a developer's tool! It can be used by end users as well to create database applications (see my blog on what Access is). I don't know of any version (other than the runtime version), that does not allow compiling into an ACCDE.

    Was this answer helpful?

    0 comments
  3. Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
    2016-08-19T15:07:25+00:00

    That techrepublic article has so many errors, it should not be quoted in polite company. This should never have passed the editor (assuming they have one).

    Was this answer helpful?

    0 comments
  4. Anonymous
    2016-08-19T10:20:37+00:00

    Office 365 might be an option?

    Basically, you are "leasing" the software versus "buying it outright".

    There are many different "versions" of Office365. Some include Access and Sharepoint, some do not. 

    https://products.office.com/en-us/business/compare-more-office-365-for-business-plans

    Office ProPlus $12.00 / mo

    I've read elsewhere that Microsoft is dropping Access from all of their Office 365 Business plans ... which frankly scares (and annoys) the bejeezuz out of me.

    http://www.techrepublic.com/article/microsoft-drops-the-ball-access-2016-not-included-in-office-365/

    I'm hoping that those of us that subscribed earlier will be "grandfathered in".

    Was this answer helpful?

    0 comments