Out of Stack Space Error 28

[Max]

Access XP with database created in Access 2K and still in 2K format. When
clicking a command button on a form that should open a report in preview, the
Out of Stack Space Error comes up. Not always. Some times it just kicks you
entirely out of the database.
Several problems seem to occur with the database in Access XP that do not
happen when it is operated in Access 2K. What's up with that? How can I
locate all the differences that are causing these problems?
Thanks in advance for your help with this.
Max

 

[Wayne Morgan]

Can you open the report form the Database window instead of clicking the
button? If so, I would suspect the button is corrupted. Try creating a new
button and if that works, delete the old one.

 

[Allen Browne]

Usually Out-Of-Stack errors mean that something is being executed
repeatedly. That can happen with recursive code. It can also happen if you
execute an event that triggers another event that triggers the first one
again.

What code is in the command button? Does it do anything that can trigger
something else, such as closing the form, with code in its Unload or Close
event, or even Form_BeforeUpdate? Is there anything in the Report_Open
event, or other sections of the report? Does the form or report rely on a
query that contains a function that calls code? Is there any code here that
can call itself? Or is there a DoEvents that could cause the button code to
be re-entrant?

If none of those kinds of thing apply, it is possible that the database is
partially corrupt. For suggestions on approaching that, see:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html