I am trying to find a way to trap for a connection error (so that I can take a different path in the event of said error)

My handy dandy book says that ... objRS.Errors.Count ... should provide me with a way to discover if a connection has failed ... but I get an error saying that "Object doesn't support this property or method" ...

Anyone ever need to do this ... how did you go about it?

Chip Dukes

I usually check the State property of the Connection object. If its adStateOpen (=1) then all is fine.

BTW the Errors collection is part of the connection object not the recordset object.

hth
Phil