Breakpoints, phantom breakpoints

[Tylendal]

Hello..

I have used breakpoints while testig my code and have deleted them using the
clear all breakpoints from the Debut menu. I have compacted the database but
when I open it up I find the code is still thinking there is a breakpoint
when i used to have one set. I have tried many differnt ways trying to get
rid of this, even importing the database into a new db1.mdb file. Nothing
seems to remove the phantom breakpoint.

Any suggestion to correct this would be appreciated

Fred Alyea

 

[RuralGuy]

Hello..

I have used breakpoints while testig my code and have deleted them
using the clear all breakpoints from the Debut menu. I have compacted
the database but when I open it up I find the code is still thinking
there is a breakpoint when i used to have one set. I have tried many
differnt ways trying to get rid of this, even importing the database
into a new db1.mdb file. Nothing seems to remove the phantom
breakpoint.

Any suggestion to correct this would be appreciated

Fred Alyea

Hi Fred,

Here's a response to this type of problem from MVP Allen Browne
that you might want to try:
______________________________

This can happen if the project is partially corrupt, and a Decompile
should clear it.

Try this sequence:

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact

3. Close Access. Make a backup copy of the file. Decompile the database
by
entering something like this at the command prompt while Access is not
running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

4. Open Access, and compact again.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

HTH