Nesting Subreports Causes Access 2003 To Crash

[rowardHoark]

The problem only occurs with reports. Nested subforms, using information from the same tables work fine.

Other people have reported identical problems online, but no solutions were found.

The only resource with some information was:

Sub-reports crash Access (Access bug)

The 'Name Auto-Correct' feature (introduced in Access 2000) is behind a number of known Access issues (see Flaws in Access). One of these issues which DBPix users sometimes experience is a crash when using subreports. To prevent this problem turn off Name Autocorrect
Click 'Options' on the 'Tools' menu.
On the 'General' tab, uncheck all three of the 'Name Autocorrect' options.

However the suggestion doesn't help. I still receive the same:

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

I tried to create nested subreports on a different computer using 2003 version, but it made no difference.

 

[vbaInet]

Most likely a corrupt report.

What happens when you follow these exact steps?

1. Drop a control on the report, i.e. textbox or button
2. Click the Save menu to save the form.

Does it crash immediately you try to save?

 

[rowardHoark]

Most likely a corrupt report.

What happens when you follow these exact steps?

1. Drop a control on the report, i.e. textbox or button
2. Click the Save menu to save the form.

Does it crash immediately you try to save?

If I drop a control on the report and click the save button, nothing happens - Access doesn't crash.

I have also tried to create a brand new database: 3 tables, all linked with one to many. I can create a report, a subreport, but once I finish the nested subreport wizard, Access crashes, displaying the same message as in the original report:

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

 

[vbaInet]

Have you tried it on a different machine with Access installed?

 

[rowardHoark]

Have you tried it on a different machine with Access installed?

Tried to create a new database on a different computer. Again, as I click the finish button on the nested subreport wizard - the software crashes.

Update:
Tried it on several co-worker machines. All have 2003 version and all crash when a nested subreport is created.
​

 

[vbaInet]

It sounds like a problem with the Office installation. I would imagine the install was rolled to all machines by the Admin so they will all have the problem.

Do you have this version of Access on your computer/laptop at home?

Can you upload the new database you tried that keeps crashing. I've got 2003 on the machine I'm on now.

 

[rowardHoark]

It sounds like a problem with the Office installation. I would imagine the install was rolled to all machines by the Admin so they will all have the problem.

Do you have this version of Access on your computer/laptop at home?

Can you upload the new database you tried that keeps crashing. I've got 2003 on the machine I'm on now.

Problem occurs when:

Open "report" in design view. Create a subreport, based on "t_grandparents" within a subreport.

 

[vbaInet]

It looks like this is a common error and hence, a bug.

Instead creating the subreport inside a subreport, create the subreport inside the report. That is open the report that is attached to the subreport, then create the subreport in there. Save, close and go back to your main report to continue working.

 

[rowardHoark]

It looks like this is a common error and hence, a bug.

Instead creating the subreport inside a subreport, create the subreport inside the report. That is open the report that is attached to the subreport, then create the subreport in there. Save, close and go back to your main report to continue working.

A good workaround. Thank you, vbaInet!

 

[vbaInet]

No problemo!