Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    What is crashing Access (A97 - SR-2)

    This is very strange and disturbing. Last night I opened the FE of my development version of an A97 database and immediately received a Windows-level error message titled "msaccess.exe Application Error". The message body was along the lines of "... instruction 0x6517daaa referenced memory at 0x00000075" etc. The dialog box has an OK and Cancel button. OK terminates the Access environment entirely. Cancel launches a dialog box titled "Just-In-Time Debugging" with a listbox that has one item: "New Instance of Visual Studio .NET 2003". Selecting that item and folowing the prompts thru the debugging process eventually leads to it trying to debug the Common Language Runtime and msaccess.exe.

    YIKES!!!

    Repeated this several times with my application FE. Opened the BE successully as well as opening other A97 databases so I concluded that A97 itself was still functional, and the problem lay with my FE. Took a deep breath to stay calm, and shut the machine down for the night.

    Tried the same thing again tonight with the same results. Tried some additional troubleshooting:
    - able to open the database successfully when holding the Shift key.
    - Repaired the database -- message was "successful", but still crashes upon startup
    - compacted the database -- no change.

    - tried to open the startup form manually - crash
    - opened some other forms manually -- success
    - open the startup form in design view -- success. Save the form without making any changes - crash
    - create a new database and import all the database objects. Crash
    - import everything except the startup form - success
    - import the startup form - crash.

    I installed Visual Basic .NET Standard onto this machine within the last six weeks, but have opened the A97 database many times successfully since the installation.

    I **think** that I installed and deleted a new software within the last few days (dumb: can't remember exactly) that purported to use the .NET framework. But I also think that I opened the A97 database successfully since that install/uninstall cycle. I only mention this because the de###### seems to want to do something with the Common Language Runtime. What the heck has it got to do with Access 97????

    I have managed to delete the offending startup form from the FE, and imported a backup version from another database, so I **think** that I am OK again, but this behaviour is really puzzling and disturbing. Has anybody seen anything similar? Any idea of the underlying cause? The FE is fairly substantial: 13 MB compacted, 230 forms, 225 queries, 150 reports so it's not something that I would like to lose any time soon. Any insight and advice would be welcome. Computer is WinXP Pro w/ 1GB of memory.
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: What is crashing Access (A97 - SR-2)

    Ignore the message about the de######. If you have the .Net framework installed on your machine, you'll get that message even though the error has nothing to do with .Net, and you should decline the invitation to debug that way. It won't work anyhow on Access 97 ... or for that matter on Access 2003. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15> Development mdbs are much likelier to corrupt than production versions, and it sounds like you have a corrupted form. You could try doing a decompile and then recompiling, which might help. Or you might be able to import just that form from a backup copy.
    Charlotte

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: What is crashing Access (A97 - SR-2)

    good idea - I had forgotten about /decompile. It reduced the database size from 13 MB to 11 MB. Not sure whether it has fixed everything, though. After the /decompile, I opened a standard module and pressed <enter> at the bottom of the file, which caused another crash. Managed to replace that module from a backup.

    I posted the same message in usenet comp.databases.ms-access and received one reply indicating that mztools can cause the wierd .net de###### behaviour. I uninstalled mztools and now the crash does not attempt to launch the .net de######. So that part of it seems to be fixed...

    Hope there aren't any more hidden corruptions.
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

Posting Permissions

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