MDE not working

[MelissaBerrett]

I fixed my swithboard so you have to use the exit to quit the DB using the ideas posted by others, but now I can't make and MDE file. Any reason why this is happening? Thanks!

 

[ajdesalvo]

Have you been able to successfully compile the database in the code window?

Select Debug, then Compile to see if there any complaints. If there are any problems indicated here, then the mdb will not create a mde.

Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"

 

[MelissaBerrett]

Compiles fine. I can do anything on the menu except for close the db(of course), create and mde file, or switch to design view.

 

[ajdesalvo]

Melissa,

I am not sure what you have for code on the load of the switchboard that may be prohibiting this. Can you open the application holding the shift key down. This would by-pass the startup code.

Then see if you can get to the compile and create mde stuff.
Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"

 

[MelissaBerrett]

Thanks for your help, but I think I could explain this better. When I use the sample below, it works great, but also disables the design view button and my ability to create an MDE file. My program still runs and compiles. Any ideas on how to get that MDE working?

Option Compare Database
Option Explicit

Public AllowClose As Boolean

Private Sub Form_Load()
AllowClose = False
End Sub

Private Sub Form_Unload(Cancel As Integer)
Cancel = Not AllowClose
End Sub
Private Sub cmdClose_Click()
On Error GoTo Err_cmdClose_Click

AllowClose = True
DoCmd.Close

Exit_cmdClose_Click:
Exit Sub

Err_cmdClose_Click:
MsgBox Err.Description
Resume Exit_cmdClose_Click

End Sub

 

[ajdesalvo]

As I suspected in my earlier post, you need to start the program by holding the shift key down while clicking on it to open.

This will by-pass the code on your form that disallows the form to be closed.

Then continue to hold the shift key down while you compact and repair, then create the mde.

Both compact and repair, and creating the mde requires that the form be closed, with your code it never can.
Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"

 

[MelissaBerrett]

Thanks for your help!