[AccessD] Access 97 Report problems

Doug Murphy doug at murphyscreativity.com
Thu Feb 12 17:03:06 CST 2004


Folks,

I have a database that has been running at a client site for some time
that has started having an interesting problem.  The background is that
when they ship an order three reports are printed, shipping invoice,
shipping document, and a core return slip if core items are involved.
This week all three computers using the system started giving an "Out of
stack space" message when the Core Return slip report was supposed to be
printed.  I looked at past threads on this plus a few articles on the MS
site.  The typical cause is a recursion that fills the stack or objects
not being closed.  Not the case here.  The report causing the problem
has no code and is based on a fairly simple query.  

I can not re-create that problem on my Access 97 development machine,
which is ancient (Pentium 233) compared with the clients machines.  Mine
works fine.  We are running the same version, which is only a couple of
weeks old. I logged onto the clients machine through PCAnywhere and
tried opening the problem report in preview mode; it shut down Access
with no messages.  Did this several times and got the same result.
Thinking possibly I had a corrupted report I created a new report and
copied the objects over.  Still shut down Access when I ran it.

The one change at the client is they moved from a novel server to Win2k.
All other databases and this one except for this report seem to be
working fine so I don't' see that the conversion is the problem, but as
I have said before, I am not a network person.

Has anyone seen anything similar to this?  I am running out of things to
try.  The database was recently decompiled, recompiled and compacted to
get it's size down.  Every thing else is running fine.

Thanks in advance for any assistance.

Doug







More information about the AccessD mailing list