Access Shutting Down On An Error When a Query Is Run

[Wayne Aprato]

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]

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
//////////////////////////////////////////////