Apologies in advance for what I'm guessing may be a trivial question.
Assume the following:
1) multi-user environment
2) standard (i.e. not a class module) module with:
Public strSample as String
3) first user user opens app at 9:00 and runs code that results in
setting the variable strSample to "abc"
4) first user keeps the app open, but does nothing with the app for 2
minutes
5) second user opens app at 9:01 and runs code that results in setting
the variable strSample to "xyz"
6) second user keeps his/her app open, but does nothing with the app
for 2 minutes
7) at 9:02, first user returns to using the app, and runs code that
needs to interrogate the contents of the variable strSample
Question: is there any risk that at step #7 when the first user runs
code that interrogates the contents of strSample, that variable will
contain "xyz" (set at 9:01 by second user) rather than "abc" (set at
9:00 by first user)?
As you can tell, I have a fundamental lack of understanding how
applications manage address space in a multi-user environment. I
would guess that, even though this is a multi-user environment and the
variable is declared 'Public', that each user gets his/her own address
space, and that there is no risk that the strSample variable that got
set in the first user's address space will get 'stepped on' by the
second user. But, that's just conjecture on my part...hence the
question.
Thank you.