Table names of Access from DAO 1

[fordtran]

There are many threads here for reading table names in an access database, but all the solutions seems to be for ADO. Anybody that can help me with extracting that in DAO.

Thanks


fordtran

 

[Sumitdev]

Public Sub PrintTableNames()
Dim t As DAO.TableDef
For Each t In dbCurrent.TableDefs
    debug.print t.Name
Next t
Set t = Nothing
End Sub

Where dbCurrent is your database.

 

[fordtran]

Thanks you so much

fordtran