How to force a compile through VBA code (Rather than manual)

[Guest]

Does anyone know a method to cause the VBA code for a form compile through an
action or method within the code itself? Even if it is applying an action to
the form which part of that action is a compile.

I have a front-end database that under certain conditions (frequently
reached) it imports a newer and revised form from back-end database on the
network. However I run into the infamous Error Accessing File problem. I
understand the issue, and am trying to automate the solution to the issue.

Unfortunately, due to restrictions from our IT department, I can not install
SP3 to solve the issue, and they have denied repeated requests to install it
for me (for one reason or another), and I am forced to use Microsoft's
"Method 2" way of bypassing the errors and manually opening, compiling,
saving, and closing the form.

The problem is, this occurs frequently enough that I am trying to automate
the process, and the only step I can not figure out is a way of forcing a
compile of the code behind the form.

I maintain both the front and and back end of the database, I just travel
frequently enough that it is safer and far more convenient to split between
front and back ends.

 

[Douglas J. Steele]

Why not simply replace the front-end? Far less trouble...