Start Batch file as Administrator

[BlueIshDan]

I'm running into the issue where some of my batch files don't run correctly when the Access Application runs them.

Batch File:

FOR %%F IN ("*.prp") DO IF %%~zF EQU 0 DEL "%%F"
FOR %%F IN ("*.drv") DO IF %%~zF EQU 0 DEL "%%F"

start "" "%~dp0\Start.bat"

I believe that this is because the For loops above are deleting files and don't have permissions to do it when ran from the application.

Does anyone know how I can modify this VBA to launch as Administrator?

VBA Snippet:

Shell parent_path & "\Copy_" & Get2000Or2100 & ".bat"

Thanks!

 

[BlueIshDan]

I'm thinking I might have to call to a .dll and declare a new function into the project. =/
I don't exactly know which drivers do what yet, maybe this can help someone help me! lol

 

[BlueIshDan]

Nobody able to help me with this? =/

 

[DavidAtWork]

I guess people aren't familiar with running .bat files from Access. The .bat files I have ever run has always been from the Windows task scheduler, I've never tried to run one from Access

David

 

[BlueIshDan]

Blah I guess so! Lol
I would normally run them from the task scheduler, but they are used as file management procedures because their speed cannot be beat lol.

 

[spikepl]

Not sure about this permission-stuff, but did you consider VBS? There you'd have access to the file scripting object etc..

 

[BlueIshDan]

Using vbs would be the same as using the File System Object in VBA (I think). BLAH

 

[spikepl]

Not really. Because VBS can be run as a script, similar to a BAT whereas VBA cannot as such

 

[BlueIshDan]

I mean speed wise.

 

[Galaxiom]

AutoIT has a RunAs method.

You can script the entire job in it or use it to run the bat file.

 

[BlueIshDan]

Thank you Galaxiom, I'll have to take a look at this!
Seems like a cool tool.