How to show the Navigation Pane Access 10 in Windows 8.1?

I have an Access accdb developed in Access 10 on Windows 7.  When I put it on my Windows 8.1 machine running Office 13.0 the Toolbar appears very briefly and then disappears.  It doesn't show the Navigation Pane.  The only options on the File Tab are Print, Privacy Options, and Exit.

I run it from the folder C:\FFNC.  l thought it might be to do with Trusted Locations.  I added the appropriate Registry setting for Office 13.0, but it didn't help.

Additionally, Special Access keys don't work.

Any assistance gratefully received.

Thanks in advance.

Clive
Clive BeatonAccess DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

OddyWriterMr.Commented:
Press F11, can solve it?
0
Clive BeatonAccess DeveloperAuthor Commented:
F11 doesn't solve it.
0
OddyWriterMr.Commented:
Hold the SHIFT key, while open your file.
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Are you sure you added the registry keys correctly?

You may have a bad install of Access or Office. Try repairing or reinstalling them on the machine.
0
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
hi Clive,

if pressing SHIFT while the database is opened doesn't get past the problem and special keys have been disabled so F11 doesn't work, you can change the database properties with this great free tool by Bill Mosca:

Properties Setter
by Bill Mosca
http://www.thatlldoit.com/Pages/utilsaddins.aspx

have an awesome day,
crystal
0
Luke ChungPresidentCommented:
Sounds like the Toolbar option is turned off.

Open the database with the shift key held down. Go to File, Options. Click on the Current Database item on the left border.

Scroll down to the Ribbon and Toolbar Options section.

Check the Allow Full Menus box:
toolbar-option.PNG
Close and reopen the database.
0
Clive BeatonAccess DeveloperAuthor Commented:
I really appreciate your help, but I am still struggling with this.

Assuming this may be a trusted locations issue, I tried Bill Moscas page for Addpath but it didn't have a version for Access 13.0.  I downloaded and tried AddPath2013 from Access Hosting but nothing appeared in the registry trusted locations (via regedit).  

If any one give me the code to create HKEY_CURRENT_USER\Software\Microsoft\Office\13.0\Access\Security\Trusted Locations\FFNC, I'll write a one-off app  to do it

Assuming this may be an Options setting in the current database, I downloaded and tried Properties Setter from That's Do It website but that didn't have any effect.

Luke: As I said above, Shift/F11 doesn't have any effect.

I'll keep working on it.

Clive
0
Luke ChungPresidentCommented:
There's no such thing as Access 13.0. Do you mean Access 2013 (version 15)?

I never mentioned Shift/F11. Are you saying you can't even open File, Options from your database?
0
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
hi Clive,

you are almost there! Get the Access 2010 version -- it will work with 2013 too :)

Bill's Properties Setter is a great tool, and one that every developer should have in their kit ;) ~

have an awesome day,
crystal
0
Clive BeatonAccess DeveloperAuthor Commented:
Sorry, Luke.  Access 2013.  And Yes I am saying that I can't  can't even open File, Options from the database.
0
Clive BeatonAccess DeveloperAuthor Commented:
Some progress.  I can open the .accdb  (and see the File Options, Nav Pane, etc) if I start Access and then open the accdb from there, but not from a desktop shortcut or double click on it in a folder.

Clive
0
Luke ChungPresidentCommented:
If you can see File, Options, did you change the settings for the Ribbon as I suggested? That's the reason they are turned off.
0
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
hi Clive,

After you take it out of the Zip file, OPEN Bill's Properties Setter. It is not an add-in, it is a stand-alone utility where you browse to the database you want to see or change options for.

to open database without running startup stuff, instead of double-click the file from a folder:
single-click the file to select it
hold down SHIFT while you press ENTER
keep holding Shift until Access fully opens

you can also put code in there to show or hide the database window so if it is opened without being able to get to it, you can still get to it ;)
' show or Hide the Database Window
'~~~~~~~~~~~~~~~~~~~~~ DB Window
Sub HideDBWindow()
   DoCmd.SelectObject acTable, "MyTablename", True
   RunCommand acCmdWindowHide
End Sub

Sub UnHideDBWindow()
   DoCmd.SelectObject acTable, "MyTablename", True
End Sub

Open in new window

WHERE MyTablename is the name of a table in your database.

have an awesome day,
crystal
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Clive BeatonAccess DeveloperAuthor Commented:
Luke.  I can't  can't open File, Options from the database.  This is the problem.
0
Luke ChungPresidentCommented:
In your earlier comment you said you could open access, then the database, and see File, Options. Did that change?
0
Clive BeatonAccess DeveloperAuthor Commented:
Luke:  That is only if I open Access first then open the accdb from within Access, but I want to open the accdb from a shortcut on the desktop.
0
Luke ChungPresidentCommented:
Yes. After you change that option, the database will open with the whole ribbon when you open it from the shortcut.

It's currently set to hide the toolbars and behaving the way the setting should.
0
Clive BeatonAccess DeveloperAuthor Commented:
Luke: When I open it from Access I get:
Access-Options-from-Access.JPG
When I open it from the Shortcut I get
Access-Options-from-Shortcut.JPG
0
Luke ChungPresidentCommented:
It's almost visible. Scroll down the list for the current database, and check the Allow Full Menus box that I mentioned originally.
0
Clive BeatonAccess DeveloperAuthor Commented:
Thanks, Crystal.  I can't get that code to work but I might get it to run when I have some more time.

Thanks to everyone else.

I even created a new database and imported all the objects but it didn't work from a shortcut either, so I am giving up on this now.

Clive
0
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
you're welcome, Clive ~ happy to help

To get the database to open without running code that turns things off from the shortcut, you can modify the shortcut to add a switch run a macro instead ... that perhaps does nothing except prevent the AutoExec macro from running, assuming that is where the goodies are

You can use a command button's click event to run UnHideDBWindow.  The command button can be tiny and Transparent so it only works if you know where to click ;)
-- be sure to modify "MyTablename" to the name of a table in your database

~crystal
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.