 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / December 2005Same Global Variable Name/ 2 Access Apps?
Someone told be today that if you have two Access applications that have the a Global (Public) variable defined with the same name, that they could overwrite each other. I've always that that each instance of Access has it's own memory blocks allocated and global variables stored in those blocks were only for that instance of Access. Does anyone know which is correct? Thank you. AFAIK, your understanding is correct. Setting a global variable X in application 1 will not impact the value of global variable X in application 2. Along the same lines, user 1 setting the value of global variable X will not impact the value of that variable in user 2's application.  SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > Someone told be today that if you have two Access applications that have the > a Global (Public) variable defined with the same name, that they could > overwrite each other. I've always that that each instance of Access has it's > own memory blocks allocated and global variables stored in those blocks were > only for that instance of Access. Does anyone know which is correct? Thank > you. Don't think so. Because it would mean that if you started two (or more) instances of Access on the same PC that you would end up with assorted conflicts between the two. > Someone told be today that if you have two Access applications that have the > a Global (Public) variable defined with the same name, that they could > overwrite each other. I've always that that each instance of Access has it's > own memory blocks allocated and global variables stored in those blocks were > only for that instance of Access. Does anyone know which is correct? Thank > you. >Someone told be today that if you have two Access applications that have the >a Global (Public) variable defined with the same name, that they could >overwrite each other. I've always that that each instance of Access has it's >own memory blocks allocated and global variables stored in those blocks were >only for that instance of Access. Does anyone know which is correct? Thank >you. Maybe that person meant to say two different Modules instead of two different Access applications. SignatureMarsh MVP [MS Access] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.