3

In MS access 2010, if I create a brand new project, the ribbon has a lot of options and actions.

But if I open an existing project, created in MS access 2003, I can't see any of those tabs. Does this just have to do with it being a 2003 .mdb? Or is there some other issue that could be causing this?

access

KyleMit
  • 6,865

3 Answers3

4

Found it! You have to navigate to options (the only way I could do this was by going to File > Privacy Options which took me to the full options page).

Then click on Current Database and make sure that Allow Full Menus is checked

Access Menu

KyleMit
  • 6,865
1

Press Alt + F11 to activate the Visual Basic interface.

Create a new Module, or select an existing one, and insert the following code at the end:

Function recoverToolbar()
  DoCmd.ShowToolbar "Ribbon", acToolbarYes
End Function

Then press F5 to run your code, and your toolbar will reappear.

KyleMit
  • 6,865
Steve can help
  • 554
0

This same issue may happen when transferring MS Access files from a machine with windows 7 - Office2013 to a Machine with windows 10 - Office2016. To Fix: Right Click any access file and select properties. Should Read... Type of File: Microsoft Access Database(.accdb) Opens with: Microsoft Access "CLICK" [Change...] button Microsoft Access will show as an other option...click/select it from the other options group! then click Apply then Ok in the properties window and try opening your files again. Nonsense...but works.

well work for me, Thanks to Jim B. with the company IT Team.

SuperGuest
  • 1