Crash and Burn

[chrisaroundtown]

I have a few reports which crash access whenever I try to open them in print preview mode or design view mode. Some of these reports come from crosstab queries and a few of them have sub reports. Access also crashes when I try to view the queries that are attached to these reports.

Does anyone have any insight to stop me from hurling abuse at my screen?

Thanks
Chris

 

[KenReay]

Hi

Does "crash" mean you get an error message, if yes what is it?

have you done a compile, to eliminate syntax errors

Possibly you have database corruption, have you tried repair, or the more drastic step of creating a new empty db and importing all of your objects into it



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[chrisaroundtown]

I get the error

"Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience."

I am done compact and repair but it doesn't seam to have any effect. If you don't know what else it could be then I will just move the objects to a blank database and hope it fixes the problem.

Thanks
Chris