SubReports number limit for a Report?

[JohnA]

Hi,

I' m using msaccess 2003 to manage a db app that contains our company data.
The size of the .mdb is about 180MB and it has about 50 tables, >100 queries,

50 forms, >50 reports, many macros and some modules.

The problem:
I created a complex report (it contains 4-5 linked subreports) and it was
working fine till I added one more linked subreport. Then the report couldn’t
be run. An error message appears that displays the message "too complex
calculations" or something like that.

The question:
Is there a limit here regarding the number of subreports that I can add to a
report?
Maybe the problem isn't the number of subreports, but the number and total
complexity of all the queries that I'm using to the report and it' s
subreports.

Note:
When I'm running the subreport as a standalone report, it opens and it's
working fine.
The problem is when I'm adding & linking the subreport to the main/complex
report.

Is there anyone with such an experience?

Thanks in advance,
John

 

[a a r o n . k e m p f]

nobody with 1/10th that much data.. should be using MS Access

upsize, upsize, upsize!

 

[JohnA]

Finally, it wasn't any subforms limit problem.
The problem had something to do with the link between the main and sub
reports.

Yes, I know we must change to something bigger, but in our case it's not so
easy to do it.
We use Access because we can create very fast and easy forms, reports and
everything.
I have some experience in Oracle and MySql(little), but I think that it
requires more time to create the frontend, so I did not change it yet.
I often need to add fast many new things to the app, and I think that using
let's say oracle and java will take much more time to do it, isn't that right?

 

[BruceM]

The size of the app is well within Access' capabilities. There are
legitimate reasons for using SQL Server, but as you have discovered the
problem was not with the database engine. Anyhow, you can use SQL Server
for the back end with an Access front end. There are groups that cover this
process. A groups search should turn up quite a bit of discussion on the
topic.

 

[a a r o n . k e m p f]

yah I've got better forms and reports using Access Data Projects than
you do in MDB land.

it's the same environment-- but you get the power of stored
procedures.
SQL Server rocks dude. Find a Windows XP box, install MSDE 2.0 (you
can find it the easiest if you look for MS SQL Server 2000 SP4) and
then hit <FILE><NEW><Project (New Data)> or <Project (Existing Data)>

Forms and reports are much more fun when you have a real database--
and you don't need to worry about constantly relinking, copying
queries.. I Just think that it's silly that most people make their
users wait 3 seconds while all the queries get updated.

SQL Server 'just works' and it is always faster and easier.

-Aaron