ADOX in vb6 and access97



I'm trying to update a database structure from another (updated) database.
When i'm creating the missing fields i can't determine the field properties.
I can find what is the name of the missing field, i can determine its type,
but for instance if the field is a 'Yes/No' field i'm not able to determine
if in the field properties the value 'necessary' is true or false, or if it's
index or not, and if it is, what type of index its using. Is there any way to
do this (find and set the field properties)?
The code i'm using is this:

Private Sub iniciaTabela(ByVal strNomeTabela As String, ByRef myTable As
ADOX.Table, _
ByVal tabelaDestino As ADOX.Table)
Dim intContador As Integer
Dim intIndex As Integer
Dim intInnerIndex As Integer
Dim intIndexColumn As Integer
Dim intInnerIndexColumn As Integer
Dim col As ADOX.Column
Dim bolFound As Boolean
Dim bolIndexFound As Boolean
Dim strErrInfo As String
Dim ADOXindex As New ADOX.Index
Dim intProperties As Integer


On Error GoTo ErrHandler

For Each tabelaDestino In Cat2.Tables
If myTable.Name = tabelaDestino.Name Then

For intContador = 0 To myTable.Columns.Count - 1
bolFound = False
For Each col In tabelaDestino.Columns
If col.Name = myTable.Columns.Item(intContador).Name Then
If col.Type <> myTable.Columns.Item(intContador).Type Then
strErrInfo = "Erro ao tentar actualizar o TIPO de
campo na base dados " & m_bdDestino & " através da base de dados " &
m_bdOrigem & " na tabela " & col.Name
col.Type = myTable.Columns.Item(intContador).Type
End If
If col.Attributes <>
myTable.Columns.Item(intContador).Attributes Then
strErrInfo = "Erro ao tentar actualizar os atributos
de campo na base dados " & m_bdDestino & " através da base de dados " &
m_bdOrigem & " na tabela " & col.Name
col.Attributes =
myTable.Columns.Item(intContador).Attributes
End If
If col.DefinedSize <>
myTable.Columns.Item(intContador).DefinedSize Then
strErrInfo = "Erro ao tentar actualizar o 'defined
size' de campo na base dados " & m_bdDestino & " através da base de dados " &
m_bdOrigem & " na tabela " & col.Name
col.DefinedSize =
myTable.Columns.Item(intContador).DefinedSize
End If
If col.NumericScale <>
myTable.Columns.Item(intContador).NumericScale Then
strErrInfo = "Erro ao tentar actualizar o 'numeric
scale' de campo na base dados " & m_bdDestino & " através da base de dados "
& m_bdOrigem & " na tabela " & col.Name
col.NumericScale =
myTable.Columns.Item(intContador).NumericScale
End If
If col.Precision <>
myTable.Columns.Item(intContador).Precision Then
strErrInfo = "Erro ao tentar actualizar a PRECISÃO
de campo na base dados " & m_bdDestino & " através da base de dados " &
m_bdOrigem & " na tabela " & col.Name
col.Precision =
myTable.Columns.Item(intContador).Precision
End If
If col.RelatedColumn <