Database Main Window Disappeared

[Finedean]

Hi,
I was working on this database this morning. I closed it and when I tried to open it the main window (where we access tables, queries, etc )disappeared. I tried repair and compact but it did help. All I see when I open the database is the toolbar (Database). Anyone has an idea what to do to recover it.

thanks

Dean

 

[Remou]

Has the database window got hidden? Have you tried pressing F11? Or looking under Windows on the MenuBar for Unhide?

 

[Finedean]

Thanks for replying.
I tried F11, hide and unhide are shaded.
Dean

 

[Remou]

Have you tried holding the Shift key while opening the database? This should over-ride start-up settings.

 

[Finedean]

Yeah, I tried the shift Key..
Could a code(s) that I added cause the problem?
I added the following codes before it disappeared:

Private Sub cmdShrink_Click()
ShrinkMe (Me.Name)
DoCmd.Close
End Sub


thanks

 

[Remou]

What does ShrinkMe do and when does this run? The line DoCmd.Close will close the database, not just the form, if the form has lost focus.

 

[Finedean]

All it does is Shrink A Form. I guess It won't have an effect on the database. I am going to try and ask for a backup which unfortunately won't include the work I did this morning...
Thanks again
Dean

 

[Remou]

What I am trying to say is that if this code runs at start up, it will have the effect of closing the database. You will not be able to see the database, because it has been closed. If eveything under Window on the Menu bar is greyed out, the database has been closed.

 

[Finedean]

I am sure I never put it to be part of the startup. Again thank you so much for your help.

Dean

 

[ssatech]

Unless you have security to this database....
Why not create a new database and import all your database objects into it... and remove the offending code if you think its the problem...

 

[Finedean]

Thanks ssatech.
I tried that but without success.