Results 1 to 11 of 11
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access quits accidentally (Access 2000)

    I wonder if anyone has this experience: I have a main menu which opens other forms. However, once a while when the other forms close and return to the main menu, Access quits completely and back to Windows 2000. There is no pattern to follow. It just happens randomly. I have checked my machine and there is no virus and I have also re-installed Office completely as well.

    Thanks

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access quits accidentally (Access 2000)

    All I can think of that might be worth checking is have a look in the table

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

    Re: Access quits accidentally (Access 2000)

    When you say it happens randomly, do that mean it happens intermittently from the *same* form, or that it happens from different forms?

    One of the causes I've seen for this behavior is mixing DAO and ADO in the same routine or calling an ADO function from the middle of a DAO routine. I just make a point of carefully keeping the two object models separate. If I start a function or Sub using DAO, I stay with DAO trhoughout that routine, and the same with ADO.
    Charlotte

  4. #4
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access quits accidentally (Access 2000)

    I am NOT using the switchboard. I simply created a form with a few buttons. These buttons will open other form via the on-click event:

    docmd.close
    docmd.openform "frmTrans"

  5. #5
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access quits accidentally (Access 2000)

    Not the same form, it could be any form. I don't use DAO in any of the forms.

  6. #6
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access quits accidentally (Access 2000)

    >>>>>docmd.close
    >>>>>docmd.openform "frmTrans"<<<<<

    From your code snippet I see you use

  7. #7
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access quits accidentally (Access 2000)

    I'm not sure if this explains the problem. I do have a form that contain a combo box and a list box that are using unique value property.

    The following is from Microsoft's knowledge base:

    When you initially set the RecordSource property of the form to a parameterized stored procedure, and you expand the UniqueTable property (by opening the combo box), Microsoft Access tries to execute the stored procedure to retrieve the specified unique table. But, the execution of the parameterized stored procedure is not successful. When you then change the record source of the form to a different record source (a table or a query), and you view the form in Form view, or you try to close the form, Microsoft Access quits and produces an error message. Because the UniqueTable property does not successfully execute the parameterized stored procedure, Microsoft Access quits.



    RESOLUTION
    To resolve this problem, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).

    To obtain SR-1/SR-1a, click the article number below to view the article in the Microsoft Knowledge Base:

    Q245025 OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)



    STATUS
    Microsoft has confirmed this to be a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Office 2000 SR-1/SR-1a.

  8. #8
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Access quits accidentally (Access 2000)

    This article (Q248932) applies only to Access Projects (.adp files), so unless that is what you are using, it is not the problem.
    Wendell

  9. #9
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Access quits accidentally (Access 2000)

    Try searching the MS knowledge base under Access 2000 for "quits unexpectedly" and you will get a list of several possible things that can cause that. In particular you might want to look at Q322794 which suggests that Name Autocorrect be turned off. That feature has been known to cause all sorts of grief.
    Wendell

  10. #10
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access quits accidentally (Access 2000)

    Thanks Wendell,

    I just did that as you and the kbs suggested. So far so good and the system has not quit unexpectedly. This also seems to be a problem with Access 2002 as well.

    Thanks again.

  11. #11
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Access quits accidentally (Access 2000)

    That feature has been indicted as the cause of a number of problems. It was a half-hearted attempt to provide developers with a built-in "Speed Ferrett " like tool to change names, but it only does half the work and generally causes problems. We usually turn it off when we start a development and leave it that way.
    Wendell

Posting Permissions

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