Change Environment String

[usachrisk]

Hello

I'm trying to change an environment-string through VBA in Access. It doesn't even have to be perminant, just so that the module runs correctly I need to have it change the PATH statement. I know I have used ENVIRON to get the current string, but it doesn't appear I can use it to change the path.

Many Thanks.

 

[Travis]

Look up the ChDir and ChDrive Statements.

 

[usachrisk]

Hi Travis -

Thanks for your reply, however I don't see how either command will help me. The reference I'm using searches only the folders in the PATH statement.

Thanks Again,
Christopher.

 

[Travis]

Christopher,

The Path statement and Environ Statements are "read only". To change the path you need to use the ChDir (or Change Directory) and the ChDrive (or Change Drive) commands.