F
Fred Wing
I have made application in Access 2000 using a complex
form for Data entry and creating a complex report based on
a dozen of linked tables and several dozen of queries. The
report is diplayed correctly on screen, but when I try to
print, I receive the message "cannot open any more
databases" (Runtime Error 3048) and the report is printed
with some of the data missing. When I print directly
without displaying, it works fine.
Unfortunately MS Knowledgebase does not know this problem!
I have searched the hole Web and found many questions
about, but only few answers.
The reason can't be lacking memory (occurs even with 1
GByte which is not used by 20%), and not undestroyed
objects because the problem occurs with newly with the
very first time as well.
It is said to be a problem of limited table handles
(1024 ?), which MS Access uses not only for tables and
queries, but also for combo boxes, subforms, subreports
etc.
But why are additional handles needed for Printing, when
the result is diplayed on screen?
I hope that someone (may be at Microsoft ?) knows more
about and can give detailed information to help the many
developers having this problem.
form for Data entry and creating a complex report based on
a dozen of linked tables and several dozen of queries. The
report is diplayed correctly on screen, but when I try to
print, I receive the message "cannot open any more
databases" (Runtime Error 3048) and the report is printed
with some of the data missing. When I print directly
without displaying, it works fine.
Unfortunately MS Knowledgebase does not know this problem!
I have searched the hole Web and found many questions
about, but only few answers.
The reason can't be lacking memory (occurs even with 1
GByte which is not used by 20%), and not undestroyed
objects because the problem occurs with newly with the
very first time as well.
It is said to be a problem of limited table handles
(1024 ?), which MS Access uses not only for tables and
queries, but also for combo boxes, subforms, subreports
etc.
But why are additional handles needed for Printing, when
the result is diplayed on screen?
I hope that someone (may be at Microsoft ?) knows more
about and can give detailed information to help the many
developers having this problem.