TableDefs and name

[srabani]

Hi Everybody,

I am srabani I am new to this site.

I am working on VBA DAO and come accross with a code

For Each tbl In CurrentDb.Table Defs
If InStr(1, tbl.Connect, "DSN=Speakers_B ureau;") > 0 Then

q1 = tbl.name

q2 = "*" & Mid(tbl.SourceT ableName, 5)
sql1 = "SELECT " & q1 & ".* " & _
"INTO [" & q2 & "]" & _
"FROM " & q1

DoCmd.RunSQL sql1
My question is What is CurrentDb.Table Defs is returning to tb1?
what is tb1.name returns to q1, is it name of each table that is currently linked with the datasource name Speakers_Bureau "
What is the difference betwn name and sourcetablename property?

Thanks .