Dim iCmpt As Integer Dim MyDB As Database Dim SQLQry As String Dim iNbr1 As Integer Dim sTblCour As String Set MyDB = DBEngine.OpenDatabase("C:\bd1.mdb", True, False) iNbr1 = MyBD.TableDefs.Count - 1 For iCmpt = 0 To iNbr1 sTblCour = MyBD.TableDefs(iCmpt).Name ' Les noms commencant par "MSys" sont des tables systèmes de Access If (StrComp(Left$(sTblCour, 4), "MSys", vbTextCompare) <> 0) Then SQLQry = "DELETE * FROM " & sTblCour & ";" MyDB.Execute SQLQry, dbFailOnError 'Else End If Next iCmpt MyDB.Close