Catch ADO errors

[Sandman83]

Hi All,

I'm trying to find a way to either catch ADO errors or test an ADO connection with VBA. The standard "On Error GoTo" statements don't catch them.

Thanks,

Tim

 

[Darrylles]

Tim,

This should give you some pointers:

http://msdn.microsoft.com/en-us/library/aa172288(office.11).aspx

ATB

Darrylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience.

 

[kjv1611]

I think you'll need to provide some more information.

For one thought, I believe that Access VBA cannot capture error messages that are coming from SQL Server or other external sources. I believe the error handling has to be done at the external source.

--

"If to err is human, then I must be some kind of human!" -Me

 

[SkipVought]

Hi,

Are you wanting to check for VB errors or SQL errors?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[JoeAtWork]

In your error handler, loop through the Errors collection in your ADO Connection object.