Skip to Content

Solved: How do I display NavPane when running accde on server with Access 2016 Runtime installed?

Question/Problem Description

We have been compiling an application to .accde format since 2007. The application doesn’t expose the Navigation Pane (NavPane) window, but I have included keyboard shortcuts and password to open the window and it’s always worked well from the ACCDE. This allows me to check data in tables and queries, relink tables if necessary and I can even modify queries.

We just recently started using Access Runtime and found out that we don’t have this option. We do already have a custom ribbon and have found that there is also no right-click functionality in Runtime.

Using MS Access accde file. I have the following line of code:

DoCmd.LockNavigationPane False

I then follow this with

Docmd.SelectObject acTable, , True

This will display the NavPane window where I have access to the tables and queries in the compiled version.

This works great EXCEPT when running the accde on a server with Access 2016 Runtime installed. In that instance the command

DoCmd.LockNavigationPane False

Brings up the Error 3709: The search key was not found in any record. The detailed error message is as below:

Error # 3709
The search key was not found in any record.
Error # 3709. The search key was not found in any record.

Run-time error ‘3709’:
The search key was not found in any record.
Run-time error '3709': The search key was not found in any record.

Run-time error ‘3709’:
The search key was not found in any record.
Run-time error '3709': The search key was not found in any record.

Is there any method to display the Navpane window when running an accde file under Access 2016 runtime?


NavPane is for editing the Access database but Runtime is only to “run” the Access databases where no extra functionality is included. There is no way to do it. You’d have to create your own and display it as a form to show the tables and queries.

When running accde and runtime, be sure to have an accdb for development, including exposure to the navigation pane. Do your development in .accdb. Runtime does not allow ANY design or development capabilities. You can’t even put a form or report in design view using code in runtime.

You are also going to need to supply your own ribbon functionality. Reference: Understand and download the Access Runtime

You use the runtime version when you have an Access app fully developed and ready to go. It’s not meant to be used for development or troubleshooting. You might wan to check out Dale’s tool which he developed exactly because of this: Access Shortcut (right-click) Tool

Alex Lim is a certified IT Technical Support Architect with over 15 years of experience in designing, implementing, and troubleshooting complex IT systems and networks. He has worked for leading IT companies, such as Microsoft, IBM, and Cisco, providing technical support and solutions to clients across various industries and sectors. Alex has a bachelor’s degree in computer science from the National University of Singapore and a master’s degree in information security from the Massachusetts Institute of Technology. He is also the author of several best-selling books on IT technical support, such as The IT Technical Support Handbook and Troubleshooting IT Systems and Networks. Alex lives in Bandar, Johore, Malaysia with his wife and two chilrdren. You can reach him at [email protected] or follow him on Website | Twitter | Facebook

    Ads Blocker Image Powered by Code Help Pro

    Your Support Matters...

    We run an independent site that is committed to delivering valuable content, but it comes with its challenges. Many of our readers use ad blockers, causing our advertising revenue to decline. Unlike some websites, we have not implemented paywalls to restrict access. Your support can make a significant difference. If you find this website useful and choose to support us, it would greatly secure our future. We appreciate your help. If you are currently using an ad blocker, please consider disabling it for our site. Thank you for your understanding and support.