Viewing Database Window

[Guest]

In Tools->Startup I have deselected the option to show the database window
(primarily because the database is complete).

Every now and then, somethings happens which means I need to inspect an
underlying table or query.

Is there a way of accessing the database window without going back to
Tools->Startup, selecting the option and restarting the database?

 

['69 Camaro]

Hi.

Is there a way of accessing the database window without going back to
Tools->Startup, selecting the option and restarting the database?

Select the Window -> Unhide... menu and select <DatabaseName> : Database (Access
2000 file format) to open the Database Window.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.

 

[missinglinq via AccessMonster.com]

Sure, hold down <Shift> and open your db.

In Tools->Startup I have deselected the option to show the database window
(primarily because the database is complete).

Every now and then, somethings happens which means I need to inspect an
underlying table or query.

Is there a way of accessing the database window without going back to
Tools->Startup, selecting the option and restarting the database?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

['69 Camaro]

Another way is to press <CTRL><G> and type the following into the Immediate
Window:

DoCmd.SelectObject acTable, ,True

Press <ENTER>, then return to the Access window, <ALT><F11>.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.

 

[Larry Linson]

In Tools->Startup I have deselected the option to show the database window
(primarily because the database is complete).

Every now and then, somethings happens which means I need to inspect an
underlying table or query.

Is there a way of accessing the database window without going back to
Tools->Startup, selecting the option and restarting the database?

Your post does not say, nor necessarily imply, that you only have the
production database, but could be so understood. I'd suggest that, even for
personal applications, it's a good idea to keep a "development" database for
the purposes you mention, and for maintenance and enhancement... the
development database would, of course, not block access to the database
window. (And, if you don't already have a systematic backup plan, the time
to plan and implement is now.)

Larry Linson
Microsoft Access MVP

 

[Dirk Goldgar]

In Tools->Startup I have deselected the option to show the database
window (primarily because the database is complete).

Every now and then, somethings happens which means I need to inspect
an underlying table or query.

Is there a way of accessing the database window without going back to
Tools->Startup, selecting the option and restarting the database?

Does pressing F11 do it for you? Unless you've also unchecked the "Use
Access Special Keys" option, it should.