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.
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.
Comment