A voir également:
- ADO access, recuperer la requete d'access sans la reecrir dans le code
- Récupérer données json (javascript) - Conseils pratiques -Javascript
- Vb access - Conseils pratiques -Visual Basic / VB.NET
- Access sql date ✓ - Forum SQL
- Access like ✓ - Forum SQL
- Syntaxe de l'opérateur LIKE dans ACCESS - Forum Visual Basic
4 réponses
essai plutot ce bout de code :
Dim cnn as ADO.Connection
Dim cmd As ADODB.Command
Dim rst As ADODB.Recordset
Set cnn = New ADODB.Connection
With cnn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.Open "C:\STAGE\pays.mdb"
End With
Set cmd = New ADODB.Command
Set rst = New ADODB.Recordset
With cmd
.CommandType = adCmdText
.CommandText = "toto"
.ActiveConnection = cnn
End With
Set rst = cmd.Execute
Dim cnn as ADO.Connection
Dim cmd As ADODB.Command
Dim rst As ADODB.Recordset
Set cnn = New ADODB.Connection
With cnn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.Open "C:\STAGE\pays.mdb"
End With
Set cmd = New ADODB.Command
Set rst = New ADODB.Recordset
With cmd
.CommandType = adCmdText
.CommandText = "toto"
.ActiveConnection = cnn
End With
Set rst = cmd.Execute
