Calling parametrized stored procedure from MS Access

Hi
I am trying to pass date parameters from MS Access form to stored procedure on SQL server . When I execute the code I am getting an error on "qd.execute " The error message is

Number: 3065
Source : DAO.QueryDef
Text: Can not execute selected Query.


I am pasting the code here so If someone have any idea what would be the problem

Dim db As Database
Dim qd As QueryDef
Dim rs As Recordset
Dim fld As Field
Dim datStartDate, datEndDate As Date

'Getting the user inputs from Ms Access form
datStartDate = [Form_Archive Information].StartDate
datEndDate = [Form_Archive Information].EndDate
Set db = CurrentDb ' Setting the database as current Database
On Error Resume Next
db.QueryDefs.Delete ("GCS_PQ_ARCHIVED_RECORDS") 'deleting the old defination of pass-through query
On Error GoTo ErrorHandler
Set qd = db.CreateQueryDef("GCS_PQ_ARCHIVED_RECORDS") 'define new query defination
qd.ReturnsRecords = False ' Query do not retrieve records
'Connection string
'user id and password is deliberately hide before posting the code
qd.Connect = "ODBC;DSN=DSN_RACK_BARREL; UID=kabxxxx, PWD=xxxxx;DATABASE=RACKBARREL"
qd.SQL = "Exec GCS_SP_Archived_Records " & "'" & datStartDate & "'" & ", " & "'" & datEndDate & "'"
qd.Execute
qd.Close

ErrorHandler:
DisplayDAOError


Note: I Already add teh The reference libraries Microsoft ADO 3.6 reference library
I have permission on databse and all the related tables .
if I run the above pass-through query in development mode it works.
stored procedure was tested .

The problem is on db.execute line. It fails whenever I run the code
I also check the permissions on related tables for the user used in connection string. I don't know where the problem is.

Please help !!!!

You should use an Access Project instead of DAO, what version of Access are you using?