By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,140 Members | 1,301 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,140 IT Pros & Developers. It's quick & easy.

Access Shutting Down On An Error When a Query Is Run

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"Wayne Aprato" <cq*******@volcanomail.com> wrote in message
news:4d**************************@posting.google.c om...
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.

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


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.