Queries that through you out of the program???

[michael]

When I click on my query it will not open, but instead
throws me out of access. Why is this? can anyone please
be of assistence!

 

[Ivar Svendsen]

Hello.

This sometimes happens to me as well. Most times it is
caused by changing names of a table field, by using
reserved words as field names, calling userdefined
functions in SQL while there is compile errors in the
module.

Note: You should backup your database before trying all
this...

* Try to compact & repair the database.
* Try to compile & save all modules
* Try to open the query in design view, then delete some
fields to see if it still crashes. Delete the first half
of the fields, then restore and delete the second half.
This will probably cause errors in the query, but you need
to find out if it crashes or not.
* Try to start access with /decompile.
* Try to export all objects to a new database.

Mostly I use Access 2002 and sometimes (quite frequently,
actually) I have to use the last option (export to a new
database) in order to keep everything working.

Regards,
Ivar Svendsen

 

[michael.]

Thanks for that.
I have solved the problem by deleting the query entirely
and importing the same query from my backed up database.
Just another reason why backing up is so important.