Code to stop Module running

[coolcatkelso]

Hiya

is there a code that will stop a module from running so it can be deleted?
________
Children prilosec

 

[llkhoutx]

Have tried <Ctl-Break>?

 

[boblarson]

1. a module doesn't run, procedures in the module run.

2. you don't need something to stop the procedure, you need to re-think your design of what it is.

3. I know you want something to run the first time the database is opened and then you want to delete the module. That is actually not a good idea. You compile into an MDE or ACCDE to protect your code. You can't do that if you are going to try to delete a module.

You should set a flag (probably a database property) when it first runs and then from that point you flip the flag and if the flag is set you don't run whatever code it was.