OnClick not firing

[richard1941]

I am the dba for a small non-profit. I manage an access database by evolving the front end at home, then move it to the production computer. I have done this successfully more than 25 times, but with the latest revision, when I move the new front end and link it to the production back end, none of the OnClicks in any of the forms work. I have tried setting breakpoints, but they never get reached.



Any ideas?

Richard

[John_G]

Does other code (if any) work, or is it just the On Click events?

If you restore the previous version, does it work? If yes, then something you changed has failed. Did you compile the code after making changes? You should do that after copying to the production PC anyway, just to be sure everything works.

[richard1941]

Good question. In fact AfterUpdate does not work either. I just compiled the code, but no behavior changed.

[John_G]

Is the database in a "trusted location" as far as Access in concerned? In there any message that appears on startup referring to that, and whether or not code is allowed to run?

It sounds as if Access is preventing any code from running.

[richard1941]

I don't know anything about trusted locations. The only message on startup of a freshly loaded new frontend is that it can't find the backend. The previous version still runs.