Results 1 to 9 of 9

Thread: Sudden Death

  1. #1
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011

    Unanswered: Sudden Death

    I have an "app' that's built in Access that has been running for about a year now and has gone through 13 revisions (additions, updates).

    This morning I added a form that uses an existing query and button to open that form on another form. It tested fine, so I relinked the tables to the server back end.

    Now, every time I touch code, Access crashes. Whether by opening a module in design view, or by opening a form in design view and then viewing code, or opening a form that calls code, Access crashes - complete App Level crash with the error reporting and all.

    I relinked the tables back and the issue remains.

    Now what do I do?
    have fun!

    Todd S.
    click to email


    Independent Development Consultant
    Biz db & reports - SQL, Access, Crystal, Seradex and more
    Small, custom, unique programs - Office, VBA, .NET


    _________________________________________________
    Favorite message from Windows:
    There was an error displaying the previous error message

    Sadly, there was no error number to look up ...

  2. #2
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011
    I even thought I would be "tricky" and I opened a different project, opened the VB editor, and then opened my problem child.

    ... same result - Access crashed.

  3. #3
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Did you try to create a new database then import all objects from the "deceased" one?
    Have a nice day!

  4. #4
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011
    yes, and if I import a module, or a form with a module attached, it crashes Access.

    The last thing I changed before the problem was adding a button with an "open form" macro and then relinking the tables to the network. Hardly seems like that would cause it.
    Last edited by tcace; 08-10-11 at 11:26.

  5. #5
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011
    also, if I try to delete an object with code attached, it crashes. If I delete an object that does not have code, it does not crash.

    So, the problem appears to specifically be with modules. I am reinstalling the service pack for Office 2010 to see if it helps.
    Last edited by tcace; 08-15-11 at 08:25.

  6. #6
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011
    aw, shucks! I was hoping to return and find somebody else experienced the same thing and shared how they fixed it!

  7. #7
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Fortunately, yours is not a common situation, and I'm not surprised that nobody else experienced it. I would have suggested to use the undocumented Application.SaveAsText method to export the objects, then use the Application.LoadFromText method to re-import them, but this can't work if you cannot open the VBA editor at all.
    Have a nice day!

  8. #8
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011

    Success!

    Assuming the problem was corruption in a module that the regular "repair" didn't see (it has a class module - does the compact and repair miss those?)

    I did this to fix it:
    1) Copy and paste to a new location
    2) Rename it
    3) Open in bypass
    <these steps trigger the "You need to click to Enable Content" warning>
    4) Remove the icon
    5) Remove the startup form option
    6) Close (close after each step that leaves it open)
    7) Run the command line option /decompile
    9) Run the command line option /compact
    10) Run the command line option /repair
    11) Copy and paste (just to make a quick backup in the new state)
    12) Open, enable content and set the icon and startup form

    Not really sure why it works, but certainly not complaining!
    have fun!

    Todd S.
    click to email


    Independent Development Consultant
    Biz db & reports - SQL, Access, Crystal, Seradex and more
    Small, custom, unique programs - Office, VBA, .NET


    _________________________________________________
    Favorite message from Windows:
    There was an error displaying the previous error message

    Sadly, there was no error number to look up ...

  9. #9
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Glad you could find a solution and thanks for sharing!
    Have a nice day!

Posting Permissions

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