code stops without breakpoint

[Lhuffst]

I have a system that all of the sudden, it stops at the first line of a function. It will continue without problem when I press F5. I tried to do compact and repair but it still happens. I have made sure there were not any breakpoints but the problem still exists. It doesn't require any references since it's just refreshing a calculation off a recordset but I don't know what to try next. Any ideas?
Does it matter if you do a compact and rebuild on a server? should it be moved locally first?
Thanks
lhuffst

 

[Remou]

Does the code compile? Have you tried a clear all breakpoints and a decompile?

 

[Lhuffst]

Is compiling when you make an mde? We are using it as an mdb file right and I haven't done any compiles (at any that I'm aware of) in access.

 

[Remou]

You can compile from the code window (Debug->Compile). Code compiles 'on the fly' even if you do not explicitly compile, but compiling is a good way to spot problems.

You can find out about decompiling here:

http://www.granite.ab.ca/access/decompile.htm

 

[Ed2020]

When I had this problem I added a breakpoint to the line where execution was stopping, then remove all breakpoints (Debug > Clear All Breakpoints). This seemed to solve the problem.

Are you using Access 2003? Just curious...

Ed Metcalfe.

Please do not feed the trolls.....

 

[jmgaddis]

I've had this happen many times... very annoying.

I believe what has worked for me is to go to the line below your code where it stops and completely retype the line (retype, not copy and paste the original line), then delete the line where it stops (or comment it out).

Hope this helps.

Thanks,
John

 

[Lhuffst]

Thanks Everyone. As an immediate fix, I did the retype line and it works fine. However, I am now looing at the compile to make sure I don't have any other issues.