Database opening in code module

[Flea]

I have a 2002 database that has been working for several years. When the front end database is opened a form opens that grabs the user id and their security level then goes through coding to re-link the back end tables and then opens the switchboard form.

Starting today, when the database is opened it is breaking out to the code window as if it has hit an error or a breakpoint. But there is no error or breakpoint in the code. If I tell it to continue it runs through the remaining code with no problem.

I've verified that there are no missing references, compacted and repaired both databases multiple times and put a breakpoint in before the line in code that it has been stopping at but can find no problem.

Any ideas on what could be causing this? A co-worker informed me that she just started having this same problem on another database. Could this be a network issue?

Thank you.

 

[CraigDolphin]

Odd. Have you checked to see if someone in your IT dept has installed a new service pack for office or Windows?

 

[Flea]

We use remote updates and I haven't seen any messages that my system needs to update anything. Just in case I ran the Install New Patches and Install New Applications then ran a repair on Microsoft Office. Unfortunately, the problem is still there. I'll have to check with IT on anything else.

Thanks.

 

[Flea]

Finally found a post on another forum with the same problem.

For the record: When a database is saved/compiled with a breakpoint phantom breakpoints can occur even though you have removed and saved the code.

Solution: Select Remove All Breakpoints and change code in any module then recompile. The phantom break disappears.

 

[CraigDolphin]

Glad you solved it and thanks for posting back the solution for others to see in future