Results 1 to 11 of 11
  1. #1
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Disable Alt F11 (A2K SR1)

    How could you disable the Alt F11 key sequence such that users can't get to visual basic mode when using a database. Also - How could you re-assign the Alt F11 sequence to one they won't expect?
    Regards,

    Gary
    (It's been a while!)

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Disable Alt F11 (A2K SR1)

    Even without disabling Alt F11, the simplest way to handle this would be to password protect your code. That will prevent them from seeing *any* code, including that behind forms and reports, no matter what keys they press.
    Charlotte

  3. #3
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Disable Alt F11 (A2K SR1)

    You can disable ALT F11 by setting Startup options (Tools) - click Advanced button, uncheck the "Use Access Special Keys" setting. Users can bypass Startup options by opening database with Shift key. This can be disabled. Do a search on "shift bypass" to find many previous postings on this topic. A simple way to hide code is to compile your database as an .MDE file. All code is saved in compiled state in an .MDE, there is no code to view. Also prevents users from opening forms & reports in design mode. Just make sure you save backup of original .MDB file. There are many previous posts re .MDE files. As noted previously you can password-protect project (Project Properties dialog). If using Access security you can set permissions on objects; in A2K the built-in User & Group Permissions dialog no longer lists modules in Object Type list but curiously enough if you install the A2K Security Manager add-in you can still set permissions on modules (which would be redundant if you use password protection).

  4. #4
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Disable Alt F11 (A2K SR1)

    Charlotte,

    Please excuse my ignorance, but how do you password protect your code?
    Regards,

    Gary
    (It's been a while!)

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Disable Alt F11 (A2K SR1)

    Go to the VBE (Alt+F11)
    Select Tools/VBA Project properties (or something similar)
    Click the Protection tab
    Lock the project and set a password

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disable Alt F11 (A2K SR1)

    Open any module.
    Select the menu Tools.
    The last line of the menu is the name of the mdb and Properties.
    Select this and select the tab Protection.
    Check Lock Project for viewing and fill in the password and confirmation password.
    Don't forget you password. <img src=/S/angel.gif border=0 alt=angel width=15 height=21>
    Francois

  7. #7
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Disable Alt F11 (A2K SR1)

    ... I set the password in VB. Thanks for the help.
    Regards,

    Gary
    (It's been a while!)

  8. #8
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disable Alt F11 (A2K SR1)

    Hi Mark

    My users all have desktop short cut pointing to client front-end ProductionAppl.mdb (wide open, unprotected system)

    I support this site via modem.

    Did I read some where, I can create ProductionAppl.mde from DevelopmentAppl.mdb and rename it to ProductionAppl.mdb and my users short cut and application will work OK?

    Other than keeping thack of what is what, are there any other ramifications to consider using this technique?

    Thanks, John

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Disable Alt F11 (A2K SR1)

    Your users can't make any design changes to objects that are code containers in an mde. The tables and queries are still there, but everything else is compiled, so don't try anything that changes the design in code because it won't work.
    Charlotte

  10. #10
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Disable Alt F11 (A2K SR1)

    You can certainly change the file extension of a .MDE to .MDB and existing shortcuts will still work, and the database is still really a .MDE, you can't open forms or reports in design mode or see any code. (Tested just now & worked OK.) But wouldn't it be easier to change the shortcut to point to the .MDE file?? But if you are not onsite at user's location maybe not. I'm not aware of any ramifications other than having to keep track of which .MDB is real & which isn't. If you do employ this method whatever you do keep a backup copy (or copies) of your master .MDB in a safe location.

  11. #11
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disable Alt F11 (A2K SR1)

    Hi Mark

    25 clients, 100's miles away, on site every 6 mos or so, this is just a temp solution til I get on site.

    Thanks, John

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •