I am a total novice at VBScript and am having trouble making my script work.. The script is used to update an access record if it matches the required phone number.. I have tried very hard to get this working but am stuck as get an error message 'Class Not Defined ADODB"...

I am sure it is only a simple error but i am totally los..

Here is my code i would be really grateful if someone can help me get it to work..

Thanks in advance Matt

' Initialize Connection object.
Set cnnDB = New ADODB.Connection
strDBpath = "C:\Program Files\VoiceGuide\Scripts\recruitment\database\Pros pects.mdb"
' Specify the Microsoft Jet 4.0 provider and then open the
' database specified in the strDBPath variable.
With cnnDB
.Provider = "Microsoft.Jet.OLEDB.4.0"
.Open strDBpath
End With

strSQL = "UPDATE NamesList SET DialingStatus='$RV[OutDial_Result]' Where PhoneNumber='0034661180060'"

' Close Connection object and destroy object variable.
Set rs = Nothing
cnnDB.Close
Set cnnDB = Nothing