Home » Access Tips And Tricks » Dealing with Access NavPane visibility

Professional Access developers understand, and rarely violate, the unwritten rule that Access database objects should not be directly exposed to users.  Unfortunately, when Microsoft fielded Office 2007, we found that the database window had been removed and replaced by the Navigation Pane, commonly referred to as the NavPane.  Although I actually prefer the NavPane to the database window, it has one down-side; once hidden, it will automatically be revealed by any use of the TransferDatabase, TransferSpreadsheet, or TransferText method in our applications.

This shortcoming can be overcome with relatively limited coding effort and the use of the TableDef object.  I’ve written a brief article on the subject with code samples and encourage you to read it if you are or have encountered this problem.




Leave a Reply

Your email address will not be published. Required fields are marked *

Name *
Email *