Database Window, Hidden when Database is opened (MS Access 2000)

Topic

New Reply

Hello All!

I’ve got a database, developed in MS Access, that is set to open up to a form (and hide the database window). I’d like to create a button on the form that when clicked would open the database window. Any ideas? So far I’ve found out the F11 on the keyboard will open the database window, but can I program this using vb on the button to act as though the user pressed the F11 key and open the database window? Also, I found a reference to StartupShowDBWindow Property but I don’t know how to use it. The database would already be open anyway before the user would press the button to open the database window so I am not sure if this property would even work.

Any one got any ideas?

Thanks in advance,

Amanda

Reply | Quote

Replies

You can use SendKeys for this:

    SendKeys "{F11}", True

Note: I use this for my own purposes when designing/testing application where database window is normally hidden. This “option” is NOT available to the end-users of application, and is disabled in Startup options. I would not recommend making database window visible to users under normal circumstances.

HTH

Reply | Quote

I second Mark’s comment – you don’t want to have the average user able to see and work in the database container window.
Why? Well, they can delete objects that the database needs, such as tables, queries, forms and reports (unless you activate security). In addition, they can edit records in tables that cause referential integrity problems, and you have no idea who did it or when. We like to use security and hide the database window, and we then capture information about who changed what when using hidden fields on the form they are required to use. Forms also make it much easier for users to figure out what data to edit and where to edit it. Just the opinions of one who has been there and been burned.

Reply | Quote

Here’s what I use behind a transparent button on my switchboard forms:

DoCmd.SelectObject acForm, Me.Name, True

What this tells Access is to select the current form object in the database window.

Reply | Quote

Thanks so much guys! I understand the the approach of not letting them see the Database Window – trust me, I’ve been burned before too. But, when you are a small pawn like me there isn’t much I can say to make them change their minds (other then laugh in the faces when they delete a table…)

Thanks again,

Amanda

Reply | Quote