Re: Access 2007 anomaly

On Sep 12, 8:18 pm, "Allen Browne" <AllenBro...@xxxxxxxxxxxxxx> wrote:
Lou, this problem can occur in all versions of Access.
A decompile usually fixes it.

Try this sequence as a way to fix it now and reduce the chance of it
recurring:

1. Uncheck the boxes under:
Office Button | Access Options | Current Database | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Office Button | Manage | Compact/Repair

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 (holding down the Shift key if you have any startup code),
and compact again.

5. Open a code window.
Choose Options on the Tools menu.
On the General tab, make sure Error Trapping is set to:
Break on Unhandled Errors
and the Compile on Demand is unchecked.

6. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

--
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.

<lgeastw...@xxxxxxxxx> wrote in message

news:1189644004.473296.161380@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

I have a weird problem in Access 2007.
I've been working in A07 for about 2 weeks when this thing began
occurring.
I'm working in the VB Code Editor and set break points for event
procedures.
The weird thing is sometime the code breaks and sometimes it doesn't
at the very same spot.
Does someone know if this is a bug in A07?
I'm stumped
Lou

Allan
This seems to have helped
Thanks

.

Relevant Pages

  • Re: Access 2007 anomaly
    ... A decompile usually fixes it. ... Open Access, and compact again. ... Still in the code window, choose Compile from the Debug menu. ... Fix any errors, and repeat until it compiles okay. ...
    (comp.databases.ms-access)
  • Re: DAO Error
    ... You should be able to uncheck the utility one. ... Then go to Debug, Compile. ... you'll need to fix them. ...
    (microsoft.public.access.conversion)
  • Re: OUTLOOK EXPRESS 6.00.2900.2180 & XP SP2
    ... and then uncheck the option in Tools/Options/Read to Read ... All Messages in Plain Text which should fix the problem: ... > b) Most of my emails block the pictures.... ... how to upgrade my OUtlook Express... ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: outlook express 6
    ... Can you see the list of messages, but the message body is blank? ... done it, shutdown and restart Windows. ... then see if the fix in this article applies: ... Read and uncheck Read All Messages in Plain Text. ...
    (microsoft.public.internet.mail)
  • More about Resolution Resetting problem
    ... 1st fix= using WinRE and running StartUp Repair and rebooting and resetting ... graphics and rebooting. ... 2nd fix= To uncheck an option, "Base Video", in the StartUp Menu under ...
    (microsoft.public.windows.vista.hardware_devices)