MS Access 2007 MDE Forms Issue

[aball65]

Some of my MS Access 2007 MDE forms don't work, specifically the forms which open other forms. There is no error message. The MDB version of these same forms work fine and other forms within the MDE (i.e., those that manipulate database data) seem to work fine too.

Any help or direction on how to debug the problem would be greatly appreciated.

 

[vbaInet]

So do they work when in normal accdb format? Paste the whole block of code where the call to open a form is performed.

 

[ajetrumpet]

Some of my MS Access 2007 MDE forms don't work, specifically the forms which open other forms. There is no error message. The MDB version of these same forms work fine and other forms within the MDE (i.e., those that manipulate database data) seem to work fine too.

Any help or direction on how to debug the problem would be greatly appreciated.

saying that something "doesn't work" doesn't say anything. care to elaborate on WHAT doesnt work?

 

[missinglinq]

Are you opening the forms thru VBA code? Code does not run in 2007 unless your database resides in a folder that has been declared a “trusted” location. Perhaps you declared the folder the mdb/accdb file resides in as "Trusted," which is why it works, but did not declare the folder the mde/accde file resides in as "trusted."

 

[aball65]

Here's a sample of the code that does not work when run from the .mde:

Private Sub RM_Module_Click()
On Error GoTo Err_RM_Module_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "R_MENU_FRM"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_RM_Module_Click:
Exit Sub

Err_RM_Module_Click:
MsgBox Err.Description
Resume Exit_RM_Module_Click

End Sub

To simplify things, I've moved all my files (i.e., _be.mdb, .mdb (uncompiled front end), .mde and .mdw) to the same directory. Even after doing this, the code continues to work when called from the .mdb but does not work when called from the .mde. I do not get any errors when I generate the .mde or when I try to run the code from the .mde.

 

[vbaInet]

Private Sub RM_Module_Click()
On Error GoTo Err_RM_Module_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "R_MENU_FRM"
DoCmd.OpenForm stDocName, , , stLinkCriteria

MsgBox "Is form Loaded?: " & CurrentProject.AllForms("R_MENU_FRM").IsLoaded & _
vbCrLf & "Is Open?: " & Application.SysCmd(acSysCmdGetObjectState, acForm, "R_MENU_FRM") = acObjStateOpen

Exit_RM_Module_Click:
Exit Sub

Err_RM_Module_Click:
MsgBox Err.Description
Resume Exit_RM_Module_Click

End Sub

I've just added a block of code to test if the form gets loaded and whether it is open. Run it with that code in and post back with what comes up in the message box.

 

[aball65]

I added the line of debug. When I run the uncompiled form (.mdb) a message box with the text "False" inside a popup with an OK button is displayed along with the R_MENU_FRM. When I run the the compiled form (.mde) nothing happens.

 

[SOS]

Try importing everything into a blank database shell (import not copy and paste) and then try making the MDE file from that and see if it still doesn't work.

 

[aball65]

Can someone help me with the import process? I currently have an _be.mdb, .mdb and a .mde file.

BTW, I converted all of these to MS Access 2007 and encountered the exact same problem with the .accde file.

 

[vbaInet]

There really isn't a process for importing into a new database shell.

Can you post your db? Zip, upload and reply - removing any sensitive data of course.

 

[SOS]

Can someone help me with the import process? I currently have an _be.mdb, .mdb and a .mde file.

BTW, I converted all of these to MS Access 2007 and encountered the exact same problem with the .accde file.

To import to a new shell you just go to the BLANK database on the main opening area of Access when you don't have any database open and then name it something and click CREATE.

Then you can close the table1 that is there at the beginning and then go to EXTERNAL on the tabs and select ACCESS database (Access logo) and then just select your database you are importing from and then it will list your items. Go to each tab and click the SELECT ALL button and then after you've done that for each tab (Tables, Queries, Forms, etc.) then you can click the final button which will import them all. Then you can either choose to save or not save your import steps and then go on from there.

 

[gemma-the-husky]

I had a large Access 2003 mde, that wouldnt run correctly in A2007.

And as you now mention it, it was the same thing - subforms wouldnt open

I had to convert it to A2007, and produce an accde, then it was fine.

I think you will have to have two versions, depending on which Access your users have.