Database Window?

[dsfcom]

This may seem silly and I've seen no mention of it in this forum yet but the "Database Window" from previous versions of Access is now called the "Object Browser"? I had code to hide the database window on startup but can't seem to find a way to hide the object browser on startup. Any ideas? Also, is there another way to view my objects in ACC07 because this way is slowing me down tremendously! It's much more difficult to find the objects I'm trying to work on and visually see where I left off. Any help would greatly be appreciated! Thanks in advance.

 

[Rabbie]

If you want to hide the navigation panel (which appears on the left side of the screen) you can switch it off from Access Options --> Current Database Navigation and uncheck the box for Display Navigation Panel. I hope this helps

 

[dsfcom]

See that's where I'm confused. The box is already unchecked but the navigation pane still displays? I currently have this code in the first form that opens then closes upon db startup that sets database options for ACC2000/2003. Not sure if they all apply to 2007 but they all seem to be working fine. Any idea what would cause the 'database explorer' to display even though it's turned off?

''KEYBOARD OPTIONS
SetOption "Behavior entering field", 1
SetOption "Arrow Key Behavior", 1
SetOption "Move After Enter", 1
SetOption "Cursor Stops at First/Last Field", False
SetOption "Ime Autocommit", False
SetOption "Datasheet Ime Control", False
''VIEW OPTIONS
SetOption "Show Status Bar", True
SetOption "Show Startup Dialog Box", False
SetOption "Show New Object Shortcuts", False
SetOption "Show Hidden Objects", True
SetOption "Show System Objects", True
SetOption "ShowWindowsInTaskbar", False
SetOption "Show Macro Names Column", True
SetOption "Show Conditions Column", True
SetOption "Database Explorer Click Behavior", 1
''GENERAL OPTIONS
SetOption "Left Margin", 0.5
SetOption "Right Margin", 0.5
SetOption "Top Margin", 0.5
SetOption "Bottom Margin", 0.5
SetOption "Four-Digit Year Formatting", False
SetOption "Four-Digit Year Formatting All Databases", False
'SetOption "Track Name AutoCorrect Info", True
SetOption "Enable MRU File List", False
SetOption "Provide Feedback with Sound", False
SetOption "Auto Compact", True
SetOption "Default Database Directory", "C:\"
''EDIT/FIND OPTIONS
SetOption "Default Find/Replace Behavior", 0
SetOption "Confirm Record Changes", True
SetOption "Confirm Document Deletions", True
SetOption "Confirm Action Queries", False
SetOption "Show Values in Indexed", True
SetOption "Show Values in Non-Indexed", True
SetOption "Show Values in Remote", False
SetOption "Show Values Limit", 5000
''ADVANCED TAB
SetOption "Ignore DDE Requests", False
SetOption "Enable DDE Refresh", True
SetOption "Default Open Mode for Databases", 0
SetOption "Default Record Locking", 2
SetOption "Use Row Level Locking", True

 

[Rabbie]

I have checked in my own 2007 DB and that option is definitely turning off the navigation pane. I am afraid I can't help you on the Setoptions as I have never used them. ALL I can suggest is that you comment out likely ones and see if that helps.

 

[dsfcom]

Great! I've commented out my SetOption lines and now it's gone. Now in design view, is there another way to view the database objects besides how they are on the left?

 

[dsfcom]

Well...the object browser seems to want to stick. On one computer I checked 'Display navigation pane', restarted the database then unchecked 'Display navigation pane' then restarted the database again and it was gone. On another computer I did the same thing but the object browser stayed! Any ideas as to what would cause it to always display? I've disabled all of my SetOption code so there must be another culprit. I've looked through the MSDN help on Access 07 options and this one doesn't look like it has coding availability to set. Any help would be greatly appreciated. Would it have anything to do with it being an ACC 2000 file?

 

[dsfcom]

Solved!

Figured this one out...had some code on startup that was only running for certain circumstances so it was running on one PC and not the other. It was creating tables during startup and I guess when you create tables at run-time the object browser displays. I've since changed my code to not create tables and do my work another way.