By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,264 Members | 1,277 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,264 IT Pros & Developers. It's quick & easy.

Where are VBA Public variables values stored on a Server

P: 2
I have an Access database on a Server which is accessed by several users via Remote Desktop. In the VBA code there are several values stored in Public Variables. I am wondering if each user who opens the database has it's own memory space on the server so that they do not overwrite the Public variables from another user? Does anyone know how Public variable data is stored in this situation?
Feb 25 '10 #1

✓ answered by Stewart Ross

Hi Dan, and Welcome to Bytes!

In the circumstances you describe, each instance of Access is running in its own memory space on the host PC accessed via Remote Desktop. If you were to check with Task Manager whilst different users are running the DB you would see each instance and the proportion of CPU resource and memory taken up by each one. There is no possibility of a conflict in the use of memory-based variables by these separate instances, as they do not 'see' each other at all.

Of course, the tables accessed by these separate instances running on a single workstation are shared and can be accessed concurrently by different users - but not the memory-based variables.

-Stewart

Share this Question
Share on Google+
2 Replies


Expert Mod 2.5K+
P: 2,545
Hi Dan, and Welcome to Bytes!

In the circumstances you describe, each instance of Access is running in its own memory space on the host PC accessed via Remote Desktop. If you were to check with Task Manager whilst different users are running the DB you would see each instance and the proportion of CPU resource and memory taken up by each one. There is no possibility of a conflict in the use of memory-based variables by these separate instances, as they do not 'see' each other at all.

Of course, the tables accessed by these separate instances running on a single workstation are shared and can be accessed concurrently by different users - but not the memory-based variables.

-Stewart
Feb 27 '10 #2

P: 2
Thanks! I thought that was the case. I'm running into an intermittant error in my program which only seems to happen in that RDP environment. Just needed someone to confirm what I thought about memory variables.
Mar 1 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.