Building FE-BE Database

[MNM]

Greetings,
I'm converting the, reworked, Instructor database to FE & BE.
Creating the individual sections is not a problem; as they stand in MDB format, everything works.

Things go awry when the FE is converted to to an MDE file.
In 2010, a security warning appears upon opening (se Security Warning.jpg).
Q1. [easy] How do I get this to stop?

When converted in both 2003 & 2010 (saved as 2000-2003 format), an error message appears (see ErrorMessage.jpg)

whenever any button on a form that updates the BE is clicked, even though the data in the tables are changed/added

correctly.
Q2. [more difficult] How can this be stopped?

The VBA Codes for the buttons are:
FRM_InstructorContactEntry
DoCmd.RunCommand acCmdSave
MsgBox ("Your record has been saved"), vbOKOnly

DoCmd.Close acForm, "FRM_InstructorContactSearch"
DoCmd.Close


FRM_InstructorInformationLookup- this does not cause the Error Message
DoCmd.CLOSE acForm, "FRM_InstructorInfoLookupSearch"
DoCmd.CLOSE


FRM_InstructorInformationUpdate
DoCmd.RunCommand acCmdSave
MsgBox ("Your record has been saved"), vbOKOnly

DoCmd.CLOSE acForm, "FRM_InstructorUpdateSearch"
DoCmd.CLOSE


FRM_InstructorVisaUpdate
DoCmd.RunCommand acCmdSave
MsgBox ("Your record has been saved"), vbOKOnly

DoCmd.CLOSE acForm, "FRM_InstructorVisaSearch"
DoCmd.CLOSE


FRM_NewInstructorEntry
UPDATE
DoCmd.RunCommand acCmdSave
MsgBox ("Your record has been saved"), vbOKOnly

CLOSE
DoCmd.RunCommand acCmdSave
MsgBox ("Your record has been saved"), vbOKOnly
DoCmd.CLOSE

Iv'e included a sample database with dummy information to aid in the investigation.
Thank you for your time,

 

[JHB]

Why do you have the DoCmd.RunCommand acCmdSave, the data is saved without that!
Below is a link to a video in YouTube, regarding the security warning.
https://www.youtube.com/watch?v=FNuh3Xuvams

 

[MNM]

JHB,
Sorry for the late reply; I've been travelling on business.
I'm not sure where the "DoCmd.RunCommand acCmdSave" came from. Maybe some code I got from some other post.
So, that would explain why the FRM_InstructorInformationLookup doesn't error out.
I'll remove the offending lines and try the conversion again.
Even so, why does it only error out upon converting to an MDE file?

As for the warning, I'll add the directory to the trusted zone.

Thanks again.
MNM