Tylendal wrote:
> 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.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
HTH
--
RuralGuy
Please reply to the newsgroup so all may benefit.
Similar Threads
