D
doyle60
I have a report that works on a database. When I split the database,
however, the report doesn't run.
When I press the command button for the report, I get the macro failure
box. Then I get a message "System Resource Exceeded. Runtime error
3035."
Of course, it works when the database is not split.
When I go to the query that the report is based on, it opens up and
everything looks fine. But it really isn't. When I try sorting the
query, picking any field, I get the error: "Cannot open anymore
databases." The Help is blank.
So I believe the report fails because it must sort.
So what is up with a query that runs but doesn't sort? And why does
this happen only when the database is split?
The report is based on a chain of queries, branching together. The
first query that fails is a union query.
Thanks,
Matt
however, the report doesn't run.
When I press the command button for the report, I get the macro failure
box. Then I get a message "System Resource Exceeded. Runtime error
3035."
Of course, it works when the database is not split.
When I go to the query that the report is based on, it opens up and
everything looks fine. But it really isn't. When I try sorting the
query, picking any field, I get the error: "Cannot open anymore
databases." The Help is blank.
So I believe the report fails because it must sort.
So what is up with a query that runs but doesn't sort? And why does
this happen only when the database is split?
The report is based on a chain of queries, branching together. The
first query that fails is a union query.
Thanks,
Matt