Access 97 closes when viewing reports

[mabris]

I have developed several databases in Access 97 (my employer doesn't want to upgrade because of conversion issues). While running these databases under both WIN2k and XP I have a probelm with the appilcation closing when I open a report (it comes up with an "Send error report?" dialog and then Access closes.) It does this sporadically, but it seems to happen more often when the report is based on a query that has its SQL defined by a VBA module. It still does it, though, when it is based on a standard defined query.

Does anyone know of any issues that might be causing this? Some of the reports are based on very simple queries, but they still exhibit this behavior. I have opened the quires themselves many times without incident, so I know that they are not the problem.

 

[SeeThru]

The only issue I have had is where a report section is set with Keep Together=Yes and the size of that section neccesitates a split. Normally the report will hang indefinetly.

Is it consistent, the same criteria giving the crash, or inconsistent? If it is inconsistent, try compiling and compacting, or even creating a new database, importing all objects and compiling the new one.