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.
.Provider = "Microsoft.Jet.OLEDB.4.0"
strSQL = "UPDATE NamesList SET DialingStatus='$RV[OutDial_Result]' Where PhoneNumber='0034661180060'"
' Close Connection object and destroy object variable.
Set rs = Nothing
Set cnnDB = Nothing