Dim cnn As New ADODB.Connection
Dim AdoRst As ADODB.Recordset
cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=sss.mdb;Persist Security Info=False;Jet OLEDB:Database Password=1111"
cnn.Open
Set AdoRst = cnn.OpenSchema(adSchemaTables)
AdoRst.Find ("table_name='aaa'")
If AdoRst.EOF Then
MsgBox "未发现"
Else
MsgBox "OK"
End If
on error goto prcerr
err.number=0
開始事務
sql語句創建表
提交事務
prcerr:
select case err.number
case 重復表的錯誤號
提示用戶表已經存在
err.clear
取消事物
case else
......
end select
exit sub
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim adors As New ADODB.Recordset
Private Sub Command1_Click()
Set adors = conn.OpenSchema(adSchemaTables)
adors.Find ("table_name='ok'")
If adors.EOF = False Then
sqlstr = "drop table ok"
conn.Execute sqlstr
MsgBox "删除OK表成功!"
Else
MsgBox "OK表不存在!,无法完成删除!"
End If
End Sub
Private Sub Command3_Click()
Set adors = conn.OpenSchema(adSchemaTables)
adors.Find ("table_name='ok'")
If adors.EOF Then
sqlstr = "create table ok (name char(10) not null)"
conn.Execute sqlstr
MsgBox "OK表创建成功!"
Else
MsgBox "OK表已存在!你将不能创建"
End If
End Sub
Private Sub Form_Load()
connstr = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=" & App.Path & "\telbook.mdb;Persist Security Info=false;Jet OLEDB:Database Password=flydragon"
conn.Open connstr
sqlstr = "select * from telbook"
rs.Open sqlstr, conn, adOpenKeyset, adLockOptimistic
End Sub