Cannot hide navigation bar in Access 2007

[Guest]

According to the documentation, if you go into Access Options, Current
Database and uncheck Display Navigation Pane this should hide it. It does
not. The navigation pane shows up the same regardless of how this box is
checked.

What is the problem?

 

[Guest]

Did you close out of Access and then reopen after setting the option?

Just as an FYI - It SHOULD work initially, however if you (or a user) hits
F11 then it will display and then when you hit F11 again it will not
completely go away.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
____________________________________
Access 2000, 2003, 2007, SQL Server 2000, Crystal Reports 10/XI, VB6
WinXP, Vista

 

[Guest]

Yes, I closed the database and reopened it. I even closed Access and
reopened it. It makes no difference.

 

[Allen Browne]

What happens when the database opens?
Do you have an AutoExec macro or a form that opens?
Is there anything there that could be causing the NavPane to be displayed?

For example, if you have a switchboard form that contains instructions to
minimize the DatabaseWindow, it will cause the NavPane to become visible.

 

[Guest]

What is happening is any function that runs the Transferdatabase command
(used extensively in the app for detaching/reattaching tables and
importing/exporting data) makes the Navigation Pain reappear. A pain indeed.
Is there some way to lock the thing down so once you disable it, it cannot
be redisplayed by F11 or any runtime function?

 

[Allen Browne]

You can disable F11 by turning off Special keys under the Access options.

But that won't affect functions.

 

[Guest]

I have since found that the docmd.transferdatabase command is a known issue
with the navigation pane. How can the pane be disabled in code?

 

[Allen Browne]

Hopefully the issue will be addressed when Office 2007 SP1 is released.

I've heard others speak of this, Steve, but I have not been able to
reproduce the problem. I don't get the NavPane appearcing when I try
something like this:

DoCmd.TransferDatabase acExport, "Microsoft Access", _
"C:\MyFolder\MyDB.mdb", acTable, "Table1", "Table1", False

 

[Guest]

I think the problem is with acLink. Try:
docmd.TransferDatabase acLink

It is good to know that it doesn't happen with exporting.

 

[Allen Browne]

Okay: we're talking linking.

If it really matters (may not, if SP1 fixes it), a workaround might be to
use the TableDefs collection to perform the linking.

 

[Guest]

Where it will matter is when linking to something other than an Access table.
Transferdatabase allows different table types, like ODBC, but TableDefs is
only for Jet.

 

[Allen Browne]

Can't you include the database type as part of the Connect property of ODBC
tables?

Values in the string are semi-colon delimited.