Find Error Description

[agfon]

I have an error number: -2147467259.

Is there a way to obtain the respective error description?

Something like...

MsgBox Err.Number = -2147467259

Results in...

"Not a valid file name."

Thanks in advance.

 

[agfon]

By-the-way, the error number -2147467259 was generated by an ADO object. Therefore, the AccessError(err#) method doesn't work.

 

[AnnabelleMarie]

Try this:

Err.Raise (-2147467259)
Msg = "Error # " & Str(Err.Number) & " was generated by " & Err.Source & Chr(13) & Err.Description

MsgBox Msg, , "Error", Err.HelpFile, Err.HelpContext

Hope this helps.

 

[VBslammer]

The ADO Connection object contains an Errors collection, see an example of how to use it here:

Extracting Error Information from ADO in VB

VBSlammer

"You just have to know which screws to turn." - Professor Bob