Building FE-BE Database

mercredi 11 mars 2015

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,

Attached Images