Colle ceci dans un nouveau projet VB6
+ Ajoute la référence dont je te parlais
+ Remplace le nom de ta DB :
Option Explicit
Private Sub Form_Load()
Dim oAccess As Access.Application
Dim oModules As Access.Modules
Dim oModule As Access.Module
Dim sLine As String
Dim r As Long
Dim t As Long
Set oAccess = New Access.Application
Call oAccess.OpenCurrentDatabase("C:\ma database.MDB", False)
Set oModules = oAccess.Modules
For r = 0 To (oModules.Count - 1)
Set oModule = oModules.Item(r)
Debug.Print "-------------- " & oModule.Name
For t = 1 To oModule.CountOfLines
sLine = oModule.Lines(t, 1)
Debug.Print sLine
Next t
Debug.Print ""
Next r
oAccess.CloseCurrentDatabase
End Sub