executing a stored query

[darre1]

not having a good day today

i'm trying to execute a stored query (update query) in a access 2000 database with the following code.

Set comUpdate = New Command
    comUpdate.CommandType = adCmdStoredProc
    comUpdate.CommandText = "qryUPDWeeklyDataFile"
    comUpdate.Parameters.Append comUpdate.CreateParameter("parPublisher", adBSTR, _
        adParamInput, , com.Parameters("parPublisher"))
    comUpdate.Parameters.Append comUpdate.CreateParameter("parWeekYear", adBSTR, _
        adParamInput, , com.Parameters("parWeekYear"))
    comUpdate.ActiveConnection = cnTemp
    comUpdate.Execute
    Set comUpdate = Nothing

i've stepped through it and it goes straight through the code, no problems, no errors etc, but when i look at the records in the datdabase using access, nothing has changed.

NOTE: I had ran the query manually using access and specified the exact same parameter values (checked them using the immediate window) and it worked perfectly.

i'm lost!