Database window appears when it should not!

[LaurenW]

My company has an A2K app that has been running just fine for a long
time. Recently, some users notice that the database window appears
when some forms are loaded.

Right before we release a version update, we set the "AllowBypassKey"
property to false. Then we convert the mdb file to an mde after
turning off the "Show database window option in the startup panel.

This appears to be happening only on Office XP and Office 2003.

Any advice?

[Deano]

LaurenW wrote:

My company has an A2K app that has been running just fine for a long
time. Recently, some users notice that the database window appears
when some forms are loaded.

Right before we release a version update, we set the "AllowBypassKey"
property to false. Then we convert the mdb file to an mde after
turning off the "Show database window option in the startup panel.

This appears to be happening only on Office XP and Office 2003.

Any advice?

Does this happen without any input from the user?

Have you unchecked the 'Use Access Special Keys'?
I'm not familiar with Office XP or 2003 but what about adding some code in
the open event of your forms to specifically hide the database window?

I found this useful info from a posting by John Mishefske earlier this year;

Public Sub hideDBwindow()
DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide
End Sub

Public Sub showDBwindow()
DoCmd.SelectObject acTable, , True
End Sub

The hide code looks like it has to select a table in the database window
which shows it and then it's a case of hiding the current window, so it
might also be worthwhile turning screenupdating off for the duration to
avoid any possible flicker.

It's a workaround I guess til you work out exactly what is causing it.

[LaurenW]

On Mon, 15 Dec 2003 22:09:15 -0000, "Deano" <de*********@hotmail.com>
wrote:

LaurenW wrote:

My company has an A2K app that has been running just fine for a long
time. Recently, some users notice that the database window appears
when some forms are loaded.

Right before we release a version update, we set the "AllowBypassKey"
property to false. Then we convert the mdb file to an mde after
turning off the "Show database window option in the startup panel.

This appears to be happening only on Office XP and Office 2003.

Any advice?

Does this happen without any input from the user?

Have you unchecked the 'Use Access Special Keys'?

ALL options are unchecked in the A2K MDB file at the time the MDE is
generated. The DB window is appearing when the user opens a form from
a menu. The DB window should NEVER be visible to the user, even if he
attempts to use the bypass key (Hold down SHIFT on launch). I say
again, this behavior only happens when running under office XP or
Office 2003 versions of Access.
I'm not familiar with Office XP or 2003 but what about adding some code in
the open event of your forms to specifically hide the database window?

I found this useful info from a posting by John Mishefske earlier this year;

Public Sub hideDBwindow()
DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide
End Sub
Thanks for the code. I'll try it.

Public Sub showDBwindow()
DoCmd.SelectObject acTable, , True
End Sub

The hide code looks like it has to select a table in the database window
which shows it and then it's a case of hiding the current window, so it
might also be worthwhile turning screenupdating off for the duration to
avoid any possible flicker.

It's a workaround I guess til you work out exactly what is causing it.

Thanks very much for your effort. This might work.
Merry Christmas!

[Deano]

LaurenW wrote:

On Mon, 15 Dec 2003 22:09:15 -0000, "Deano" <de*********@hotmail.com>
wrote:

Thanks very much for your effort. This might work.
Merry Christmas!

No problem. I did a quick search on Microsoft's KB and found these two
articles that relate to Access 2002

http://support.microsoft.com/default...b;en-us;304092
ACC2002: The Database Window Is Displayed When a Database Is Opened from the
Most Recently Used File List Even After You Clear the "Display Database
Window" Check Box
http://support.microsoft.com/default...b;en-us;313915
ACC2002: Database Window Is Displayed When You Click the Application Icon
Even Though You Turned Off the "Display Database Window" Startup Option
Another thing I would do is to create a test database with one form in it,
configure it as you are currently doing, create an MDE and test it on
XP/2003.

hth
Martin