Access Shutting Down On An Error When a Query Is Run

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Wayne Aprato

    Access Shutting Down On An Error When a Query Is Run

    I have a couple of Access 2000 and 2002 databases which have exhibited
    the following behaviour. The mdb works fine but the mde causes access
    to shut down on an error when a particular query is run. In one
    database this was happening when a command button was pushed to open a
    form based on a query. In the other it was when a drop down list that
    was based on a query was clicked.

    In both cases the problem disappeared when I recompiled the mde. What
    can cause this type of behaviour? Is there a known bug?

    Any help would be appreciated.
  • Fast Eddie

    #2
    Re: Access Shutting Down On An Error When a Query Is Run


    "Wayne Aprato" <cqdigital@volc anomail.com> wrote in message
    news:4d9a5a66.0 401292147.72f04 3fd@posting.goo gle.com...[color=blue]
    > I have a couple of Access 2000 and 2002 databases which have exhibited
    > the following behaviour. The mdb works fine but the mde causes access
    > to shut down on an error when a particular query is run. In one
    > database this was happening when a command button was pushed to open a
    > form based on a query. In the other it was when a drop down list that
    > was based on a query was clicked.
    >
    > In both cases the problem disappeared when I recompiled the mde. What
    > can cause this type of behaviour? Is there a known bug?
    >
    > Any help would be appreciated.[/color]


    i seen that 2. sometimes the hd spins for a few secs then the app is toast.
    i debugged one an found the cbf was screwed up bigtime. the mod had a query
    to chk for stuff in the onclose event of the subform. but get this. the
    subform onclose was firing right after the onopen for the main form.
    totally gay. i traced it to a corrupt subform but it didnt show as corrupt
    on an import. so i ditched it an replaced it an all is ok now. hth.
    eddie.

    ///////////////////////////////////////////////
    GIRLS CANT PLAY 9 BALL
    //////////////////////////////////////////////




    Comment

    Working...