Data provider or other service returned an E_FAIL status

Hola a todos. Estoy accesando a una base de datos sobre un servidor SQL
Server 2000.
Realizo una apertura sobre una vista e intento hacer una búsqueda pero al
intentar usar el método Find del objeto Recordset ocurre el
error -2147467259 generado por Microsoft Cursor Engine "Data provider or
other service returned an E_FAIL status"

Este es el código de la vista
CREATE VIEW [detPartes]
AS
SELECT TOP 100 PERCENT
Partes.*,
Tipos.[Tipo] AS [Tipo],
Tipos.[DescTipo] AS [DescTipo],
Tipos.[DescIng] AS [TipoDescIng],
Tipos.[Movto] AS [Movto],
Medidas.[UMedida] AS [UMedida],
Paises.[PaisCodigo] AS [PaisCodigo],
Paises_1.[PaisCodigo] AS [PaisProcCodigo],
Paises.[TLC] AS [TLC],
Aranceles.[Fraccion] AS [Fraccion],
Aranceles.[DescIngles] AS [DescIngles],
Aranceles_1.[Fraccion] AS [Fraccion1],
Aranceles_2.[Fraccion] AS [ArancelAlt],
Codigos.[Codigo] AS [Codigo],
Empaques.[Empaque] AS [Empaque],
Generos.[Genero] AS [Genero],
Subtipos.[DescEsp] AS [Subtipo],
Tipos.[Color] AS [Color],
Aranceles_3.[Fraccion] AS [ArancelCan]
FROM
Partes LEFT OUTER JOIN
Tipos ON Partes.[ipTipo] = Tipos.[idTipos] LEFT OUTER JOIN
Medidas ON Partes.[ipMedida] = Medidas.[idMedidas] LEFT OUTER JOIN
Paises ON Partes.[ipPais] = Paises.[idPais] LEFT OUTER JOIN
Aranceles ON Partes.[ipArancelUS] = Aranceles.[idArancel] LEFT OUTER

Aranceles Aranceles_1 ON Partes.[ipArancelMX] = Aranceles_1.[idArancel]
LEFT OUTER JOIN
Codigos ON Partes.[ipCodigo] = Codigos.[idCodigo] LEFT OUTER JOIN
Empaques ON Partes.[ipEmpaque] = Empaques.[idEmpaque] LEFT OUTER JOIN
Paises Paises_1 ON Partes.[ipPaisProc] = Paises_1.[idPais] LEFT OUTER
JOIN
Aranceles Aranceles_2 ON Partes.[ipArancelAlt] Aranceles_2.[idArancel]
LEFT OUTER JOIN
Generos ON Partes.[ipGenero] = Generos.[idGenero] INNER JOIN
Subtipos ON Partes.[idSubtipo] = Subtipos.[idSubtipo] LEFT OUTER JOIN
Aranceles Aranceles_3 ON Partes.[idArancelCan] Aranceles_3.[idArancel]
ORDER BY Partes.[NumParte]

El recordset se abre con los siguientes settings:
CursorLocation = adUseClient
CursorType = adOpenStatic
LockType = adLockReadOnly

Alguien quien pueda orientarme por favor.

Saludos.