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