I call a dos batch file from within ms access database by using shell command.
the dis batch file change an environment variable xyz from the its initial value 123 to 456
but the comment environ("xyz") always retreive the initial value of xyz that was set before starting the ms access aplication.
how can i refresh the environment variables within ms access to reflect their new values
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
You can use
Private Declare Function SetEnvironmentVariable Lib "kernel32.dll" Alias _
"SetEnvironmentVariableA" (ByVal lpName As String, ByVal lpValue As
String) _
As Long
to set a variable for the executing program and programs called by it (after change). But that is a session local change, i.e. after program termination the setting is gone.
dear qlemo, abqbill
thanks for the solution, i try it and it works i iniiate an environment variable to xyz=init
but in need to execute a dos batch file and need to know when it realy start. so i put in it the first command: setx xyz=started.
after i launch the batch file from within ms acces i loop on the environ(xyz) waiting to have xyz=started
but my xyz has never the value started from within ms access while if i rightclick on mycomputer to see the environment variables i can read xyz=started.
i need to change the environment variable also from outside ms acess, from dos batch file and be read from within ms access
Options are:
Business Accounts
Answer for Membership
by: AbqBillPosted on 2009-05-24 at 18:27:29ID: 24463873
Hi Esperon, the shell script (batch file) only changes the environment variable for the cmd.exe session that runs it. When that cmd.exe session terminates, so does the environment variable change. You can work around this by using some other kind of storage such as a temporary file or a registry modification. Bill.