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?
LVL 1
kpkirishyAsked:
Who is Participating?
 
blschrock23Connect With a Mentor Commented:
You are in need of server maintenance.  Check disk space, and the transaction log on SQL Server.
0
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.