requete qui marche sur access mais pas sur vb ???

SELECT [Dept] AS Département, [Operation] AS Opération, [commande].[N°com] AS N°Commande, [Date_recp] AS [Date Récp], [Date_trans] AS [Date Trans], [Date_aff] AS [Date Aff], [Centre], [Client], [Fournisseur], [Design_mat] AS Désignation, [Confir] AS Confirmation, [Date_confir] AS [Date Confirm], [Obser] AS Observation1, [N°Fact] AS N°Facture, [Date_Fact] AS [Date Fact], [Montant], [Devise], [Nbr_Colis] AS [Nbr Colis], [Poids], [Trans] AS Transporteur, [Moy] AS Moyen, [Date_arriv] AS [Date Arrivée], [N°Avis], [Doc] AS [Document Joint], [N°Doc], [facture].[N°OT] AS N°OT, [Date_OT] AS [Date OT], [Sit] AS Transitaire, [N°Inst] AS N°Instance, [Date_inst] AS [Date Instance], [N°Ordre] AS N°Assurance, [Obser2] AS Observation2

FROM (commandeLEFT JOINfacture ON ([commande].[N°com]=[facture].[N°Com]) AND ([commande].[operation]=[facture].[operat])) LEFT JOINInstance ON [facture].[N°OT]=[Instance].[N°OT];

Les Tables:

• Commande ( Dept, Operation, N°com, Date_recp, Date_trans, Date_aff, Centre, Client, Fournisseur, Design_mat, Confir, Date_confir, Obser )

• Facture ( N°Fact, Date_Fact, Montant, Devise, Nbr_Colis, Poids, Trans,Moy, Date_arriv, N°Avis, Doc,N°Doc,N°OT,Date_OT, Sit )

• Instance ( N°Inst, Date_inst, N°Ordre, Obser2 )

dans le code ca marche pas:

dim rsttous As New ADODB.recordset
dim cnx As New ADODB.Connection
dim sSQL as string

sSQL= "SELECT * from  requete(larequete en haut) where Département<>''"

rsttous.Open sSQL, cnx, adOpenDynamic, adLockOptimistic

 ca se plante et me donne une erreur (comme si il ne connais pas la requete)

merci de votre aide

t'as raison mon ami
1- l'erreur c'est "cette operation n'est pas autorisé si l'objet est fermer" comme s'il connait pas la requete

2-voila la ligne a couriger
sSQL= "SELECT [Dept] AS Département, [Operation] AS Opération, [commande].[N°com] AS N°Commande, [Date_recp] AS [Date Récp], [Date_trans] AS [Date Trans], [Date_aff] AS [Date Aff], [Centre], [Client], [Fournisseur], [Design_mat] AS Désignation, [Confir] AS Confirmation, [Date_confir] AS [Date Confirm], [Obser] AS Observation1, [N°Fact] AS N°Facture, [Date_Fact] AS [Date Fact], [Montant], [Devise], [Nbr_Colis] AS [Nbr Colis], [Poids], [Trans] AS Transporteur, [Moy] AS Moyen, [Date_arriv] AS [Date Arrivée], [N°Avis], [Doc] AS [Document Joint], [N°Doc], [facture].[N°OT] AS N°OT, [Date_OT] AS [Date OT], [Sit] AS Transitaire, [N°Inst] AS N°Instance, [Date_inst] AS [Date Instance], [N°Ordre] AS N°Assurance, [Obser2] AS Observation2
FROM (commandeLEFT JOINfacture ON ([commande].[N°com]=[facture].[N°Com]) AND ([commande].[operation]=[facture].[operat])) LEFT JOINInstance ON [facture].[N°OT]=[Instance].[N°OT] where Département<>''""

merci encore pour votre aide