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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.