the goal of the attached code is to allow different things to happen in:
MDB (development)
MDE first-run (final pre-deployment test)
MDE second and subsequent runs (the deployed application)

this is a stripped-down demo skeleton of my standard startup form for all applications. code comments include a few suggestions for stuff that you might like to include in the different 'modes' if you decide to go with a similar 'standard startup' scheme.

i hope you find it useful! at the very least it should allow you to lock down your deployed MDE with no risk of locking yourself out of your development MDB (and without the need for dubious hard-coded backdoors).

NOTES:

please examine the code to satisfy yourself that this is something you want to run. start the MDB with Shift held down to review the code.

this A2K code late-binds: no special references needed.

Tools/Startup/DisplayFormPage must be frmStartup to run 'as advertised'

in development mode (MDB) you will be prompted for your error-handling preference: respond NO to the question for the demo as-posted. the YES response might be useful later as you add new code to the startup routines.

PM me if issues.

izy