Results 1 to 9 of 9
  1. #1
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Access has to close (Access2003)

    I've got this one database with a problem.

    I think it is limited to one form. When I open the form in design mode, then make even a minor change (like move a control), and then try to close and save, I get an error something to the affect of "Access has encountered an error and has to close". I can put the database over on another computer, and I have no problems. But if I move it back, same problem.

    Both computers have Office2003 SP3. There appears to be a slight different in the builds/versions:
    The one that works: 11.8204.8221
    the other one: 11.8166.8221

    But the Office Update site says I'm current.

    On the computer that works, I even converted it back to Access2000, decompiled, then compacted/repaired. Brought it back over to the problem computer, and same problem.

    Both computers running Windows XP Pro. The problem computer was just upgraded to SP3, but problem existed before that.

    Anyone know what might cure this problem?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access has to close (Access2003)

    I don't know whether it'll help, but there are two post-SP3 hot fixes from Microsoft:

    Access 2003 post-Service Pack 3 hotfix package: December 18, 2007 - this one is a must, it solves a number of common problems.
    Access 2003 post-Service Pack 3 hotfix package: November 21, 2007 - worth a try too, although less essential.

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Access has to close (Access2003)

    Thanks Hans, it was the Dec. hotfix package that did it!

    I must have applied that hotfix to my old laptop back in December, but when I got my new desktop I just brought it up-to-date from Office Update website, never even considering (or remembering) any hotfixes. And the website doesn't mention whether or not there are hotfixes avaiable! Now I also know that the difference in the versions I observed was because of the hotfix (they are both the same now).

    Thanks again.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Access has to close (Access2003)

    Do you apply the hotfix in the RUN box after you click start or just double click on msaccess.msp that comes with the download?

  5. #5
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Access has to close (Access2003)

    Double click the download and you will be asked where to extract the files to. Put them anywhere you like, as long as you can find them.

    Then in the extracted files, double click the msp and it starts the update. Let it run.
    Regards
    John



  6. #6
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Access has to close (Access2003)

    Thanks John.
    I looked at the readme file and it said to peform it from Run, strange

    Anyway i run the msp file from within windows and it woked fine.

  7. #7
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Access has to close (Access2003)

    I have a client that has Access 2003 SP3 but dont know if they have applied the hotfix.

    Is there a way of finding out if it has been applied or not? They dont know.

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access has to close (Access2003)

    The MSKB articles about the hotfixes list the version numbers and modification dates of the files that are affected by them, so you could inspect those.
    You can see the version number of a file by hovering the mouse pointer over it in Windows Explorer. If that doesn't work:
    - Right-click the file in Windows Explorer.
    - Select Properties from the popup menu.
    - Activate the Version tab.

  9. #9
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Access has to close (Access2003)

    I have done hat with msaccess.exe on my laptop and it is the same number as mentioned in the hotfix.

    I'll check this at the clients.

    Thanks Hans

Posting Permissions

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