Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Private Sub Form_Load()
cn.CursorLocation = adUseClient
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\NWIND.MDB;Persist Security Info=False"
Set rs = cn.OpenSchema(adSchemaColumns)
Set DataGrid1.DataSource = rs
If rs.RecordCount > 0 Then
rs.MoveFirst
While Not rs.EOF
If rs.Fields("DATA_TYPE").Value = 3 Then
Debug.Print rs.Fields("COLUMN_NAME").Value & "为自动增量"
End If
rs.MoveNext
Wend
End If
End Sub