MS Acees has encountered a problem

[LB79]

Hello,

I seem to be having problems with Access and a certain query today. The query has always run OK, however I have linked a field in the query to a textbox on a form (Ive done this well before with other queries).
For some reason, everytime i try to run the query now, I get the general "MS Access has encountered a problem. Please report this to MS".
Does anyone know if this is a known glitch in Access, or if there is a way around it?

Thanks

 

[chris davies]

have you checked that the data required by the original query is not corrupted? if the query fails, it could be a cascading result. double check that the query you are calling is working correctly by running the query from the query window.

 

[gemma-the-husky]

does this mean your database keeps closing, and trying to repair itself.

you may be able to repair it directly - alternatively open a new database, andreimport everything form your faulty database.