Results 1 to 10 of 10
  1. #1
    Join Date
    Mar 2003
    Location
    Bogota
    Posts
    67

    Angry Unanswered: access is bringing me to my knees yet again!

    I can no longer step through my code. Breakpoints are ignored. 'Stop' doesn't work. I tried creating a new db and importing all objects, to no avail. Please help! I'm running 2000 on W2k.



    How can Windows be virus-prone, if Microsoft IS a virus?

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by pd9n
    I can no longer step through my code. Breakpoints are ignored. 'Stop' doesn't work. I tried creating a new db and importing all objects, to no avail. Please help! I'm running 2000 on W2k.



    How can Windows be virus-prone, if Microsoft IS a virus?
    Couple of things you can try:

    Run the compact & repair

    Compile you VBA code
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Mar 2003
    Location
    Bogota
    Posts
    67
    I tried all of that. When I create a new db, I can break sample code. But after I import all my objects from the old db, it's no more breaks.

  4. #4
    Join Date
    May 2004
    Location
    The Netherlands
    Posts
    52
    Maybe this helps:
    'Allow break into code' - property should be switched on.

  5. #5
    Join Date
    Mar 2003
    Location
    Bogota
    Posts
    67
    no, I still can't break into any code.

  6. #6
    Join Date
    Mar 2004
    Location
    San Diego
    Posts
    45
    maybe try to decompile, this sometimes helps when nothing else does. Make sure you create a backup first, like always, before decompiling.

  7. #7
    Join Date
    Mar 2004
    Location
    San Diego
    Posts
    45
    To decompile:

    **************BACKUP FIRST*********************
    1. Close all occurences of Access
    2. Hit Start menu and Run and type:
    msaccess /decompile "c:\test.mdb"
    (replace "c:\test.mdb" with full path and name to your db)
    3. Close Access after it has opened (if it opens)
    4. Open the db in Access, go to any module (ALT+F11) select Debug | Compile and save
    5. Close the db
    6. Open the db again (and hopefully all is golden...)

  8. #8
    Join Date
    Mar 2003
    Location
    Bogota
    Posts
    67
    OK, that seems to work, thank you! It reverted again when I opened a particular form, which had in its code a date variable being appended to a string, i.e.

    strMsg = "*** Current as of " & dtCurDateTime & " ***"

    When I used CStr to convert the date before appending, the form no longer causes the breaks to stop working.

    ???

  9. #9
    Join Date
    Mar 2004
    Location
    San Diego
    Posts
    45

    Talking

    One thing to note: decompile is undocumented by Micro$oft, and can have weird results, sometimes bringing the whole db down to a pile of rubbish. I personally have never experienced this, but keep this in mind, and always create a backup before decompiling (I know, I am beating this to death). Use this as a last resort.

    Happy coding!

  10. #10
    Join Date
    Mar 2003
    Location
    Bogota
    Posts
    67

    Smile

    EVERYTHING in Access is a last resort!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •