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.
User Profile
Collapse
-
Where are VBA Public variables values stored on a Server
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?
No activity results to display
Show More
Leave a comment: