Results 1 to 3 of 3
  1. #1
    Michaeldb46 is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Apr 2014
    Posts
    6

    Protect a runtime app


    I am distributing an app to 10 users. The data is shared on a server, but each client can see only his data.
    I am installing Access Runtime on those computers that do not have Access. But some users do have Access,
    so I renamed the app xxx.accdr.
    My question is, if someone knows how to open an app from inside Access using the shift key, they get a warning.
    But the warning tells them how to convert the accdr back to an accdb. Is there a way to suppress that warning?

    TIA,
    Mike

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    The only time I use accdr is while developing to test the app in RunTime. Publish as accde or distribute as accdb.

    There are various ways to loock down your app. It sounds as though you are at the point where you need to disable the shift key. I would consider using the function defined here.
    https://www.accessforums.net/securit...html#post24088

    Post #4 has some useful statements to call the function.

    Code:
    ChangeProperty "AllowFullMenus", DB_Boolean, False 'Access Full Menus.
    ChangeProperty "AllowSpecialKeys", DB_Boolean, False 'F11, ALT F11, etc.
    ChangeProperty "AllowBypassKey", DB_Boolean, False 'Shift Key Override on loading.
    ChangeProperty "AllowShortcutMenus", DB_Boolean, False 'Access Shortcut Menus. May be too severe.
    ChangeProperty "AllowBuiltInToolbars", DB_Boolean, False 'Toolbars.
    ChangeProperty "AllowToolbarChanges", DB_Boolean, False 'Prevent Changes.
    ChangeProperty "AllowBreakIntoCode", DB_Boolean, False 'Code access.
    I use some of the above in combination with
    DoCmd.ShowToolbar "Ribbon", acToolbarNo

    Practice on a copy of a copy

  3. #3
    Michaeldb46 is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Apr 2014
    Posts
    6
    Thanks for the suggestion. I've got exactly what I need.
    Mike

Please reply to this thread with any new information or opinions.

Similar Threads

  1. What is the best way to protect databases
    By AzizSader in forum Forms
    Replies: 2
    Last Post: 11-27-2013, 11:55 PM
  2. Replies: 6
    Last Post: 09-20-2012, 04:22 PM
  3. Help protect my database
    By eduardo in forum Security
    Replies: 1
    Last Post: 06-26-2012, 12:55 PM
  4. Replies: 13
    Last Post: 06-12-2012, 09:52 PM
  5. protect a database
    By NISMOJim in forum Access
    Replies: 3
    Last Post: 03-11-2012, 05:31 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums