A2002: can't execute code in break mode

[=?windows-1250?Q?Vladim=EDr_Cvajniga?=]

When I set a breakpoint I (sometimes) get an error message just before the
!breakpointed! code should be executed. The error message is "The expression
On Exit you entered as the event property setting produced the following
error: can't execute code in break mode.". Actually, I'm not in break mode.
The error mesage pops up several times but I can easily step the code after
that.

What kind of problem is that?

TIA

Vlado

 

[Arvin Meyer [MVP]]

Sometimes uncompiled code becomes corrupted in the connection to the
uncompiled code that you see in the IDE. Try copying the text of your code
into a text file, then deleting the code behind that form. Compact the
database several times then reopen the form and paste the code back in. Make
sure it's all re-attached to [Event Procedure]s in the Event property sheet
and will recompile. It should then be OK.

 

[=?windows-1250?Q?Vladim=EDr_Cvajniga?=]

TYVM for your respond, Arvin.

1) The trick didn't help.
2) It took >10 minutes to check all the [Event Procedure] are attached...
too complex form... I wouldn't like to do it quite often. ;-)
3) I'd like to point you to a non-answered post of mine @
http://groups.google.co.uk/group/mi...m+which+changes&rnum=1&hl=en#cec1df77c425e0a1
which complains project corruption.

Vlado

P.S. Answer only in this newsgroup, please.

Sometimes uncompiled code becomes corrupted in the connection to the
uncompiled code that you see in the IDE. Try copying the text of your code
into a text file, then deleting the code behind that form. Compact the
database several times then reopen the form and paste the code back in.
Make sure it's all re-attached to [Event Procedure]s in the Event property
sheet and will recompile. It should then be OK.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

When I set a breakpoint I (sometimes) get an error message just before
the !breakpointed! code should be executed. The error message is "The
expression On Exit you entered as the event property setting produced the
following error: can't execute code in break mode.". Actually, I'm not in
break mode. The error mesage pops up several times but I can easily step
the code after that.

What kind of problem is that?

TIA

Vlado

 

[Douglas J. Steele]

Check my March, 2004 "Access Answers" column in Pinnacle Publication's
"Smart Access" for code that automates this.

You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

 

[=?windows-1250?Q?Vladim=EDr_Cvajniga?=]

Thanx a million, Doug!

Vlado

Check my March, 2004 "Access Answers" column in Pinnacle Publication's
"Smart Access" for code that automates this.

You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

2) It took >10 minutes to check all the [Event Procedure] are attached...
too complex form... I wouldn't like to do it quite often. ;-)

 

[=?windows-1250?Q?Vladim=EDr_Cvajniga?=]

Still having problems with "Can't execute code in break mode". Decompile &
compress didn't help... :-(

Vlado

Check my March, 2004 "Access Answers" column in Pinnacle Publication's
"Smart Access" for code that automates this.

You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

2) It took >10 minutes to check all the [Event Procedure] are attached...
too complex form... I wouldn't like to do it quite often. ;-)

 

[Douglas J. Steele]

While decompiling should have cleaned up corruptions, you might have to
create a new database and import all of the objects from your old database
into the new one.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Still having problems with "Can't execute code in break mode". Decompile &
compress didn't help... :-(

Vlado

Check my March, 2004 "Access Answers" column in Pinnacle Publication's
"Smart Access" for code that automates this.

You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

2) It took >10 minutes to check all the [Event Procedure] are
attached... too complex form... I wouldn't like to do it quite often.
;-)

 

[=?windows-1250?Q?Vladim=EDr_Cvajniga?=]

Is there any way how to recognize corrupt database?

Vlado

While decompiling should have cleaned up corruptions, you might have to
create a new database and import all of the objects from your old database
into the new one.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Still having problems with "Can't execute code in break mode". Decompile
& compress didn't help... :-(

Vlado

Check my March, 2004 "Access Answers" column in Pinnacle Publication's
"Smart Access" for code that automates this.

You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


2) It took >10 minutes to check all the [Event Procedure] are
attached... too complex form... I wouldn't like to do it quite often.
;-)

 

[Douglas J. Steele]

Have you read the Corrupt Microsoft Access MDBs FAQ that Tony Toews has at
http://www.granite.ab.ca/access/corruptmdbs.htm?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Is there any way how to recognize corrupt database?

Vlado

While decompiling should have cleaned up corruptions, you might have to
create a new database and import all of the objects from your old
database into the new one.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Still having problems with "Can't execute code in break mode". Decompile
& compress didn't help... :-(

Vlado
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> píše v diskusním
pøíspìvku Check my March, 2004 "Access Answers" column in Pinnacle Publication's
"Smart Access" for code that automates this.

You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


2) It took >10 minutes to check all the [Event Procedure] are
attached... too complex form... I wouldn't like to do it quite often.
;-)

 

[=?windows-1250?Q?Vladim=EDr_Cvajniga?=]

Have been there earlier today... ;-)
MS guys & gals shoud visit that site, too.

Vlado

Have you read the Corrupt Microsoft Access MDBs FAQ that Tony Toews has at
http://www.granite.ab.ca/access/corruptmdbs.htm?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Is there any way how to recognize corrupt database?

Vlado

While decompiling should have cleaned up corruptions, you might have to
create a new database and import all of the objects from your old
database into the new one.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Still having problems with "Can't execute code in break mode".
Decompile & compress didn't help... :-(

Vlado
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> píše v
diskusním pøíspìvku Check my March, 2004 "Access Answers" column in Pinnacle Publication's
"Smart Access" for code that automates this.

You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


2) It took >10 minutes to check all the [Event Procedure] are
attached... too complex form... I wouldn't like to do it quite often.
;-)