Access 2003 Report Printing Problem

[Eric Heinold]

I have a report that has several (10) sub reports in it. Five of the sub
reports are in the report footer. The report displays correctly. However,
when printing this report, Access returns an "Unrecognized Database" Error 4
times, then prints the reports fine. I know the databases being referenced
are not corrupt, Access just gives that message. If I delete any 2 of the
sub reports in the footer, the message goes away, and the report prints
correctly. I have other reports that have this many subreports that work
fine. I have tried recreating the report/sub reports, but nothing seems to
fix this.

Thanks,

Eric Heinold

 

[Larry Linson]

Well, there's certainly not enough detail information here for us to try to
debug remotely. What version of Access are you using? How deep a
nesting-level, subreports within subreports, are you using? If you searched
help on Access specifications for Access 2003, you'd find (and I suspect
this may be your problem)

Number of levels of nested forms or reports 7


In some versions of Access in the past, the nesting level limit was 3 --
sound familiar?

Larry Linson
Microsoft Office Access MVP

 

[Eric Heinold]

No, there is very little nesting. I do have 2 places that nests 2 subreport
within one other one, but that is all for the nesting.

I am currently using Access 2003, but the database was created in Access
2000, and is still in Access 2000 format.

There is very little code running in the report. The subreports have only 5
lines of code to hide some controls when the start and stop date on a form
are not the same.

The subreports are using UNION queries, which seems to be part of the
problem. I have taken the UNION out of the queries, and it makes the report
print without the error. Also, deleting 2 of the sub reports (any 2) will
cause the error to stop, but of course any of these items makes the data on
the report invalid, those are just testing things I have done to try and
figure out where it is coming from.

Thanks,

Eric Heinold