Calling PowerShell script from Access 2010

[txgeekgirl1]

I had a program written in VBA which called a PowerShell script to create Exch2010 mailbox accounts for new users. Worked fabulous with Access 2003. We moved our Databases to a newer server with Access 2010 on it. I have checked reference libraries and anything pertaining to the code - everything looks good. I then consulted the Microsoft boards for calling a PS Script from Access2010 but their solution does not work. If anyone has any suggestions or solutions - much appreciated!

Access 2003 code that worked:

'Call Powershell and run connection
    Call Shell("powershell -file ""c:\scripts\NewMailbox.ps1""", vbMaximizedFocus)

Access 2010 suggestion - does not work:

'Call Powershell and run connection
    Call Shell("C:\WINDOWS\system32\WindowsPowerShell\v1.0\powershell.exe -command c:\scripts\NewMailbox.ps1", vbMaximizedFocus)

The actual code in the file does run and work from the new server - so I just need to get the Call fixed.

 

[kjv1611]

Have you checked the version number portion of the path at all? Seems like that path leaves open a lot to error. I'd verify the full path for certain.

And just to see, have you tried w/o the vbMaximizedFocus? wouldn't hurt, and simple test.


"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57