How many ActiveX controls can I have? Stack overflow problems...

[Matthew Sullivan]

Re: How many ActiveX controls can I have? Stack overflow problems...

Interesting! Our experiences are exactly opposite: all the stack
problems I've seen were coding-related.

That kind of variety is one of the things that's what makes this group
so cool!

Here's an example of code that blows the stack up:

Private Sub TestStackSpace( )
TestStackSpace
End Sub

-Matt


On Wed, 25 Feb 2004 07:53:22 -0500, "Mike Storr"
<nobody@somewhe re.con> wrote:
[color=blue]
>I believe the article pertains more to the "Overflow" error the original
>poster mentioned than what a stack is. I personally have never seen an
>overflow error that was not hardware related, just Out of Stack (or Heap)
>Space,
>
>"Matthew Sullivan" <Matt@NoSpam.co m> wrote in message
>news:n48o301uk qga0o4d7rd54a99 7nh80ccdbh@4ax. com...[color=green]
>> That's a strange definition of "stack". Methinks it is valid only
>> within the context of a certain type of problem (not the problem we've
>> got here).
>>
>> A stack is simply an area of physical memory that is used for dynamic
>> memory allocation. My hunch is that in VBA that applies to pretty
>> much everything we have programming control over, except global and
>> static variables (and constants, which probably occupy no memory at
>> all).
>>
>>
>>[/color]
>
>[/color]

[Mike Storr]

Re: How many ActiveX controls can I have? Stack overflow problems...

On Wed, 25 Feb 2004 17:36:23 -0600, Matthew Sullivan wrote:
[color=blue]
> Private Sub TestStackSpace( )
> TestStackSpace
> End Sub[/color]

Your example does exactly as I had mentioned. Runtime Error 28 - Out of
Stack Space, not the same as an Overflow.
--
Mike Storr

https://www.veraccess.com

[Matthew Sullivan]

Re: How many ActiveX controls can I have? Stack overflow problems...

OK, I've got my head out of my *ss now....

When the original poster said "stack overflow" I assumed (apparently
incorrectly) that he was mixing up his terms and actually meant "out
of stack space".

A more careful reading of the KB article you referenced shows there is
indeed such a term as "stack overflow". (Which I've never encountered
before.)

My apologies for the carelessness. Thanks for persevering!


On Wed, 25 Feb 2004 19:40:07 -0500, Mike Storr <storrboy@sympa tico.ca>
wrote:[color=blue]
>Your example does exactly as I had mentioned. Runtime Error 28 - Out of
>Stack Space, not the same as an Overflow.[/color]

[TC]

Re: How many ActiveX controls can I have? Stack overflow problems...

Jim, I still feel that your interest in stack issues, will not help you
solve your problem. The reason why the Access books do not explain the
stack, is - IMO - that it is something which you seldom, if ever, need to
know anything about, when writing Access VBA.

Your problem sounds much more like a db corruption problem, or a software
install problem, to me. The KB article was interesting, but I predict that
nothing in there, will solve your problem - unless you have an unbounded
recursion (which I suggested before).

Let us know if/when/how you eventually solve it :-)

Cheers,
TC


"Jim" <jimmy.shentz@n ospam.virgin.ne t> wrote in message
news:78a%b.2071 2$ft.11012@news fe1-win...[color=blue]
> Thanks to all who have answered my questions. Your answers have been
> extremely useful and I've learnt things that I doubt I'd ever find in[/color]
books[color=blue]
> (and I've tried pretty hard...)
>
> I'll try out some of the suggestions tomorrow and will reply with my[/color]
hotmail[color=blue]
> login (can't use NNTP through the firewall at work for my ISP).
>
> Cheers
> Jim
>
>[/color]

[Mike Storr]

Re: How many ActiveX controls can I have? Stack overflow problems...

He may very well have been mixing them up, but when you're diagnosing
things, the terminology becomes important. Maybe I'm just being to literal?
Wash your hair before going outside.


"Matthew Sullivan" <Matt@NoSpam.co m> wrote in message
news:nrnq3094a2 rbcqds8mtmssjv3 m9ag4g1sr@4ax.c om...[color=blue]
> OK, I've got my head out of my *ss now....
>
> When the original poster said "stack overflow" I assumed (apparently
> incorrectly) that he was mixing up his terms and actually meant "out
> of stack space".
>
> A more careful reading of the KB article you referenced shows there is
> indeed such a term as "stack overflow". (Which I've never encountered
> before.)
>
> My apologies for the carelessness. Thanks for persevering!
>
>
> On Wed, 25 Feb 2004 19:40:07 -0500, Mike Storr <storrboy@sympa tico.ca>
> wrote:[color=green]
> >Your example does exactly as I had mentioned. Runtime Error 28 - Out of
> >Stack Space, not the same as an Overflow.[/color]
>[/color]