Where are VBA Public variables values stored on a Server

[Dan Joosten]

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?

[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

[Dan Joosten]

VBA Public variables

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.