Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 894
  • Last Modified:

RunTime Error 23 "Out of Stack Space"

I have a MS Access Database in which I used tons of VB and the database is backed by SQL Server 2000.  There are about 10 - 15 users on at any given time.  I am recieving this error at my OpenReport commands.  Runtime error 23 "Out of Stack Space".  The funny thing is that if I log in as Server/Administrator I don't recieve that error.  Which permissions is this linked to?
0
kpkirishy
Asked:
kpkirishy
  • 2
1 Solution
 
kpkirishyAuthor Commented:
this only happens occasionally and on Some of my OpenReport commands.
0
 
Brendt HessSenior DBACommented:
Generally, an 'Out of Stack Space' error indicates that you have some form of recursion happening.  Since it does not happen as Administrator, the assumption that I would make would be:

(1)  You have a permission issue somewhere
(2)  Your code has an error trap in it
(3)  either
   (a) your error trap is receiving an error [e.g. no permissions to write the error to the specified log file], or
   (b) you have a RESUME statement that is being executed that places your execution point right back on the error, causing another error trap....

Check permissions on the reports, and on any data files linked to the report
0
 
kpkirishyAuthor Commented:
I don't even use the "On Error" statement in most of the code.  Exactly what permissions would i check?
0
 
blschrock23Commented:
You are in need of server maintenance.  Check disk space, and the transaction log on SQL Server.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now