Database window has shown after open MDE with access 2002 (can not hide!)

[pockung]

For Access 2002, I have disabled database window at menu "Tool\Start up" and created MDE file but after re-open this MDE, database window still open. What should I do?

(disable database window at "Tool\Startup" has been done and coding with VB to disable this window has been done also.)

 

[Rachael]

Hi Pockung,

did you find a solution to your problem?. I have just encountered the exact same thing and am dumbfounded, I cannot work out what has happened other than my client has 2002 but has run my database (2000) in the past on 2002 without problem. The latest upgrade is now giving my client access to the database window (actually opening up with the program in a separate window and showing everything)

I hope you have solved this problem.

Rachael

 

[ghudson]

Access 2000/2002/2003

To hide the different open forms, reports, etc. you have to set the "Show Windows In Taskbar" to false...

Go to Tools / Options, then the View tab and deselect 'Windows in Taskbar'

OR

Call DisplayOpenWindowsInTaskbar(False)

Public Function DisplayOpenWindowsInTaskbar(bDisplay As Boolean)
On Error GoTo Err_DisplayOpenWindowsInTaskbar
    
    If bDisplay = True Then
        Application.SetOption "ShowWindowsInTaskbar", True
    Else
        Application.SetOption "ShowWindowsInTaskbar", False
    End If
    
Exit_DisplayOpenWindowsInTaskbar:
    Exit Function
    
Err_DisplayOpenWindowsInTaskbar:
    If Err.Number = 2091 Then 'ShowWindowsinTaskbar is an invalid name [Access 95/97 error]
        Exit Function
    Else
        MsgBox Err.Number & " - " & Err.Description
        Resume Exit_DisplayOpenWindowsInTaskbar
    End If
    
End Function

 

[Rachael]

thanks ghudson for your reply, I will certainly be implementing your call function.

Still wondering why this has happened though. I thought for awhile I might have solved the problem, opnce apon a time I never used to be able to make an MDE without compiling the code first but now, for some reason, since updating to Win XP I can make MDE without compiling the code. So, I thought that was the problem, but, its not!!!

Has anyone else encountered this problem?

Would love to hear about it, perhaps it might help to solve the problem.

I've had a few strange things happen since going Win XP still using my ODE 2000. I originally used ODE 2000 on Win 98, but updated when my old computer died.

Kind regards,

Rachael