Results 1 to 11 of 11
  1. #1
    New Lounger
    Join Date
    Jul 2003
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ctrl - click (access97 / 2000)

    is there a way to disable the option that allows you to go straight to the database by holding down ctrl and left clicking the database?

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

    Re: ctrl - click (access97 / 2000)

    I assume that you mean holding down the Shift key while opening the database. Holding Ctrl down opens Access in safe mode, holding Shift down bypasses the startup options. You can set a property in Visual Basic that disables this use of the Shift key. Look up AllowBypassKey in the Visual Basic help (the help subject contains an example), or look at General: Securing AllowBypassKey on Dev Ashish's Access Web.

  3. #3
    New Lounger
    Join Date
    Jul 2003
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ctrl - click (access97 / 2000)

    I did mean shift!! Thanks for that I'll take a look

  4. #4
    New Lounger
    Join Date
    Jul 2003
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ctrl - click (access97 / 2000)

    found it and it looks just what I need however where does it go and how is it called?

    Many thanks

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

    Re: ctrl - click (access97 / 2000)

    How much do you know about Visual Basic in Access? If you are unfamiliar with it, I would suggest that you read up on it before trying to tackle the code to disable the bypass key.

  6. #6
    New Lounger
    Join Date
    Jul 2003
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ctrl - click (access97 / 2000)

    I know some but probably not as much as you by the sounds of it!

    Perhaps the function is called at start up as part of a module?

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

    Re: ctrl - click (access97 / 2000)

    I have no time for a full reply now. If nobody else reacts, I'll post one later on.

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

    Re: ctrl - click (access97 / 2000)

    You need to either have an autoexec macro that calls the code or a startup form that does the same. You put the code in a standard module. Unlike VB and other Office apps, Access doesn't allow you to call a routine at startup directly.
    Charlotte

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

    Re: ctrl - click (access97 / 2000)

    Charlotte has already posted a reply. I have attached a small demo database (Access 97, zipped) that demonstrates what she wrote: the general code is in a standard module basBypass, and it is called in the form frmBypass that has been set as the startup form of the database. This form offers the option to change the setting of the AllowBypassKey property. When you set the property to No, and quit, you won't be able to get to the database window by keeping the Shift key down. Normally, you wouldn't give the user the possibility to change the setting, of course; this is just a demo.

    Look at the module basBypass, and at the code behind the frmBypass form to see how it works.
    Attached Files Attached Files

  10. #10
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Emerald Beach, New South Wales, Australia
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ctrl - click (access97 / 2000)

    Holding Ctrl down opens Access in safe mode

    Wow Hans,

    I'd never heard of safe mode for access. I did a quick help search but couldn't find it. I don't suppose you could briefly outline what safe mode does or point me in the general direction of more info?

    Thanks

    Stewart

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

    Re: ctrl - click (access97 / 2000)

    I didn't even know that Access had a safe mode until this thread made me try to see what happened if I opened a database with the Ctrl key held down. I am using Access 2002; the help file has some information on "Office Safe Mode":
    <hr>User-initiated safe mode
    You can open any Office program in Office Safe Mode by pressing CTRL while you start the program or by using the /safe option when you start the program from the command line.

    The following restrictions apply when you open a program in user-initiated Office Safe Mode. (Some items listed below do not apply to all Office programs.)
    <UL><LI>No templates can be saved.
    <LI>In Microsoft FrontPage, the last used Web site is not opened.
    <LI>The Office Assistant is not automatically displayed.
    <LI>Toolbar or command bar customizations are not loaded and customizations cannot be saved.
    <LI>The AutoCorrect list is not loaded and changes are not saved.
    <LI>Recovered documents are not automatically opened.
    <LI>Smart tags are not loaded and new tags cannot be saved.
    <LI>All command line options are ignored except "/a" and "/n".
    <LI>Files cannot be saved to the Alternate Startup Directory.
    <LI>Preferences cannot be saved.
    <LI>Additional features and programs will not automatically load.[/list]<hr>
    I don't know anything more than this about it.
    Attached Images Attached Images
    • File Type: png x.png (7.2 KB, 0 views)

Posting Permissions

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