To anyone who may be interested in the answer....to overcome this problem (error 430: Class doesn't support Automation ...) and it has nothing to do with ActiveX.dll or ActiveX.exe...download MDAC_TYPE version 2.5 from http://www.microsoft.com\data

i'm a happy chappy now.