Repost of database window appears on close

[Autoeng]

This is a repost as original failed to get any responses.

When exiting my database the database window appears for a second or so. I have very novice Access users and would like to keep it that way so that I don't have to set up any more security than necessary (i.e. code to hide the window, disable the shift key, ect.). But you know about curiosity and the cat. If someone sees it for only a second they will find someone to tell them how to get in. Can anyone explain why the database window pops up on exit and if there is a way to stop it from happening? Display database window and allow special keys are turned off and I have even gone so far as to minimize the db window on exit from maintenance so that if it did appear it would hopefully only appear as a minimized window in the lower left hand corner but all of these have failed to work.

Thanks in advance,
Autoeng

 

[khood]

Autoeng,

If you haven't already, I would recommend splitting your database so that users can't get around the minimal security. Perhaps this FAQ will give you some pointers on fine-tuning your app:

http://www.tek-tips.com/faqs.cfm?spid=181&sfid=1021&newpid=181&cfid=82180228&cftoken=96863986

K.Hood

 

[Autoeng]

Database is already split. I really just want to find out why the database window is appearing on application shutdown.

Autoeng

 

[thornmastr]

Not only have I never heard of this happening, I can't make it happen. My only possible suggestion is that you might have at least one corrupted object on your database. if you would be interested, and if you are using either A97/A2k/A2K2 and would not mind, zip it and send it to me. I would like to see it happen and find out why. Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[yolly]

Have you tried this code behind your switchboard?

Private Sub Form_Close()
DoCmd.RunCommand acCmdWindowHide
End Sub

 

[yolly]

Sorry,
I didn't post all of the code.
Private Sub Form_Close()
Docmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide
End Sub

 

[Autoeng]

Thanks yolly but it still flashes. I sent it to Thornmastr and he was unable to duplicate but suggested moving it higher up in the directory structure of the server. I'm going to give that a try and see what happens.

Thanks,
Autoeng