#Error in snapshot copy

[Guest]

I have designed an application in which the user has to export a report to a
snp file to email users of the report. Recently a snap shot showed a #Error
in some of the fields. Two fields were caluculated, one field was data from
the database. When I go back and run the report and export it to a snapshot
it looks fine. The database is split, but is it possible something else was
locking that piece of data at the time the report was created and exported to
cause the error?

Sometimes when printing from report previewer I get a message " too many
databases open" Is there a way to prevent either one of these errors from
occuring?

 

[Guest]

Two months ago I got the same message "Too many databases opened..." The
reason why this may happen is because you may have too many forms opened at
any given time. The previous programmer always kept his forms opened for
performance reasons. When we wanted to print a report, we got the error.