Hi experts!

When I tried to print a report in a database in Access 2002 I got the folowing error written below. There is no error in my code.


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

Could you please help me. Thank you in advance!


michel mhanna

This happens to me from time to time. The underlying query in your report is causing an error in Windows that is making Access shut down. Even though the query may be correct, it's just triggering SOMEthing. The way I get around this is create a new database (MDB file), use Get External Data and import everything from the old database into the new one, and try it again in the new MDB. Most of the time, that will work.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division