Share via

Access DB front-end no top bar (File, Home, Create etc)

Anonymous
2023-10-25T20:21:44+00:00

When I open the access front end file (.accdb), I can only see the Form or Design View. There is no way to edit/see other things such as table relationships.

I am new to this access db and I have no prior history on it (people who created and worked on it have left and they were not pros).

The menu bar shows up momentarily when the file is opening then disappears into what the screenshot shows.

How do I get back the top bar?

Microsoft 365 and Office | Access | For business | 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
  1. ScottGem 68,810 Reputation points Volunteer Moderator
    2023-10-26T21:26:03+00:00

    the previous person wrote a VB macro that does a bunch of stuff on start of a form.

    That's what I thought was the case. Just a point here. Access uses VBA (not VB). VBA is a programming language similar to VB but with commands specific to the application. Access also includes a macro language that is separate and different from VBA.

    1 person found this answer helpful.
    0 comments
Answer accepted by question author
  1. ScottGem 68,810 Reputation points Volunteer Moderator
    2023-10-26T16:32:04+00:00

    So the developer didn't disable the Shift key. But what he did, apparently do, is use code to hide everything once an object is selected.

    You are saying the Nav Pane only shows the tables? If that's the case, then you need to right click on the top of the Nav Pane and select to view all Object. You can then right click an object, like a form, and select Design mode. You can then look at the On Open code to see what its doing to hide the Nav Pane and ribbon. Also look for an AutoExec macro or check the Options for a default form.

    This is going to take a lot of research and analysis to see what ws done to protect the app.

    1 person found this answer helpful.
    0 comments

7 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. DBG 11,711 Reputation points Volunteer Moderator
    2023-10-25T20:57:03+00:00

    Hi GroverParkGeorge,

    It is a .accdb file.

    I tried holding Enter but it only opened more instances of this GUI ;(

    Hi. I think George meant to say to hold down the Shift key instead.

    0 comments
  2. Anonymous
    2023-10-25T20:44:30+00:00

    Hi GroverParkGeorge,

    It is a .accdb file.

    I tried holding Enter but it only opened more instances of this GUI ;(

    0 comments
  3. George Hepworth 22,765 Reputation points Volunteer Moderator
    2023-10-25T20:26:58+00:00

    Try pressing and holding the enter key while opening it.

    Is it an accdB or an accdE file, by the way? If the latter, your climb is going to be a bit steeper.

    0 comments