Dim cnn As New ADODB.Connection Dim s As String s = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=计算.mdb;Persist Security Info=False" Set cnn = New ADODB.Connection cnn.Open s Dim strchtc As String strchtc = "update gztc,chtc set gztc.创汇提成=chtc.Expr1000 where gztc.ID=chtc.ID" cnn.Execute strchtc cnn.close
conn.execute "Update 表2 set uname='" & text1.text & "' where id=1 "
Dim s As String
s = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=计算.mdb;Persist Security Info=False"
Set cnn = New ADODB.Connection
cnn.Open s
Dim strchtc As String
strchtc = "update gztc,chtc set gztc.创汇提成=chtc.Expr1000 where gztc.ID=chtc.ID"
cnn.Execute strchtc
cnn.close