i am using asp and access as backend with provider being microsoft jet. i am unable to catch the errors thru’ error object in asp. i have used recordset object for all the transactions. the description of the error in error object is always the same, such as operation is not allowed in this context. but i dont get the precise error at any point of time. using connection object with execute method for transactions gives the precise error descriptions. but using recordset object, the error descriptions are very vauge. infact, the correct error descripition is being displayed on to the browser also, i hope it is coming from the microsoft jet driver (not sure), but i am not finding a way to catch hold of these correct error description for thedisplay to end users.
pls do solve this, as soon as possible.
thank u.