WMI Auotomation Error

[Jack Leach]

Hello. I'm trying to get some OS info per the following link:

http://accesstips.wordpress.com/200...formation-using-microsoft-access-vba-and-wmi/

However, I am getting an error on line 23 of sub ListWMIPropsAndValues

Set objWMIService = GetObject("winmgmts:\\" & strComputer & strWMINamespace
& strWMIQuery)

Error -2147217392 (Automation error)


I suspect this may have something to do with the WQL being passed as:

:Win32_OperatingSystem.Name='Microsoft® Windows Vista™ Home Premium
|C:\Windows|\Device\Harddisk0\Partition1'

but all attempts to reconcile have failed.

Is anyone familiar with this, or should I refer to a vista OS board.

Access 2003, Vista Home Premium
Sample download results in the same error

thanks,

--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)

 

[Jack Leach]

Thanks Patrick, I'll give this a shot within the next few days and see what
it comes up with.

--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)