Microsoft OLE DB Provider for ODBC Drivers error '80040e14'?

Question

i am getting this error
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Unknown

/top.asp, line 33
and on that line i am
ConnStr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=E:\mis\payrollnew\db\sal.mdb"
Con.open(ConnStr)
this is the line where i am getting error :
set rs_staffName=con.execute("select staffno,SName,SSurname from StaffDetails where staffno="&staff_number&"")


can any one help me

Answer 1

This site has about every reason for that error code.
http://tutorials.aspfaq.com/8000xxxxx-errors/why-do-i-get-80040e14-errors.html
I hope it helps!

Answer 2

do a simple connection to sp which returns a select * from xyz, without parameter...If ok, go ahead with parameter. I think link to db is giving failure