Conversion from Access 97 to Access 2002

I converted an Access db from 97 to 2002. Mostly the conversion went
smoothly. However I'm having a problem with some reports. Opening one of
the reports for viewing or even closing a report that is in design mode shuts
down the database AND Access completely. I tried importing the reports
directly from both the old version and from one copy of the converted file to
another; in both cases Access shuts down completely.

The queries underlying these reports seem to work ok when run by themselves.

I'm not aware of any Active X controls on the reports. The references look
to be set correctly.

Any ideas?

Thanks in advance, Dale Matt

1) Open in design view, then save as something esle. See if that new saved
version opens.

If not ...

2) Open a new blank report. Copy and paste the controls from the old into
the new. Do the same with any VBA. Then see if that new version opens.

Dale Matt wrote:
I converted an Access db from 97 to 2002. Mostly the conversion went
smoothly. However I'm having a problem with some reports. Opening one of
the reports for viewing or even closing a report that is in design mode shuts
down the database AND Access completely. I tried importing the reports
directly from both the old version and from one copy of the converted file to
another; in both cases Access shuts down completely.

The queries underlying these reports seem to work ok when run by themselves.

I'm not aware of any Active X controls on the reports. The references look
to be set correctly.

Any ideas?

Thanks in advance, Dale Matt

--
Message posted via http://www.accessmonster.com