Results 1 to 5 of 5
  1. #1
    MatthewGrace is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2013
    Posts
    159

    Most Access Features are disabled when I open the .accdb file...

    Hello, thank you for taking the time to consider my question!



    I made an Access program years ago, and I seldom do any work with it these days. Somehow, I cannot recall how, I made it so when you double click on the .accdb file on your desktop to run this program, it loads up with very reduced options. Pressing F11 produces no windows. Pressing alt+F11 will not produce the code window. The only visible tabs at the top are FILE and HOME.

    I vaguely remember doing this so other people using the program didn't accidentally open anything that wasn't in the forms themselves. I also remember there is a very very easy way to fix this but I cannot remember... I want to say I'm supposed to do some combination of holding keys while clicking on the accdb file itself and it will open as normal. I'm not even sure how to look up my question in Google so I came here to describe it.

    Does anyone know what I'm talking about? Thank you for your thoughts.
    Matt

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,940
    Try opening with the shift key pressed, and hope you did not code to prevent that. :-)
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,801
    You might be referring to File>Options>Current Database>Ribbon and Toolbar Options
    and maybe
    Navigation Options
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    MatthewGrace is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2013
    Posts
    159
    Holy Cow. I used the shift key and it worked. Funny, I tried that before posting... perhaps I just didn't press it long enough or something.

    Thank you guys!

  5. #5
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,801
    hope you did not code to prevent that
    Actually, that is not really all that hard to overcome.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Replies: 3
    Last Post: 12-21-2021, 12:46 PM
  2. Multi user access to accdb file
    By minicooper1.3i in forum Programming
    Replies: 5
    Last Post: 03-02-2020, 03:56 PM
  3. Access 2007 won't open ACCDB file
    By Paul H in forum Access
    Replies: 12
    Last Post: 03-29-2016, 08:08 AM
  4. Replies: 2
    Last Post: 05-01-2014, 01:31 PM
  5. 2007 features can't open in 2010
    By wnicole in forum Database Design
    Replies: 1
    Last Post: 10-24-2013, 12:12 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