test --------- 表名
tt -----------字段名
我是用 ADODB.Connection
Option Explicit
Dim Cnnall As ADODB.Connection
Private Sub Command1_Click()
Dim Cn As New ADODB.Command
Set Cn = New ADODB.Command
Set Cn.ActiveConnection = Cnnall
Cn.CommandType = adCmdText
Cn.CommandText = "ALTER table test ADD column tt text(30) null"
Cn.Execute
End Sub
Private Sub Form_Load()
Set Cnnall = New ADODB.Connection
Cnnall.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\WINDOWS\Desktop\s\db2.mdb;Persist Security Info=False"
End Sub