Dim Con As ADODB.Connection Dim Sql As String Set Con = New ADODB.Connection Con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\WW_SOFT\ȨÏÞ.mdb;Persist Security Info=False"
Private Sub Command2_Click() Dim Con As ADODB.Connection Dim Sql As String Set Con = New ADODB.Connection Con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c\user.mdb;Persist Security Info=False"
Dim Sql As String
Set Con = New ADODB.Connection
Con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\WW_SOFT\ȨÏÞ.mdb;Persist Security Info=False"
Sql = "Insert Into mathe Values(" _
& "'" & Trim(Text1.Text) & "'," _
& "'" & Trim(Text2.Text) & "'," _
& "'" & Trim(Text3.Text) & "'," _
& "'" & Trim(Text4.Text) & "'," _
& "'" & Trim(Text5.Text) & "'" _
& ")"
Con.Execute Sql
Con.Close
Dim Con As ADODB.Connection
Dim Sql As String
Set Con = New ADODB.Connection
Con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c\user.mdb;Persist Security Info=False"
Sql = "Insert Into mathe Values(" _
& "'" & Trim(Text1.Text) & "'," _
& "'" & Trim(Text2.Text) & "'," _
& "'" & Trim(Text3.Text) & "'," _
& "'" & Trim(Text4.Text) & "'," _
& "'" & Trim(Text5.Text) & "'" _
& ")"
Con.Execute Sql
Con.Close
End Sub
Private Sub Command1_Click()
On Error GoTo err
Dim cn As New ADODB.Connection
'有密码的连接方式
'cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\user.mdb;Jet OLEDB:DataBase password=12345;"
'无密码的连接方式
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\user.mdb;Persist Security Info=False"
cn.Open
cn.Execute("insert into mathe values('" & Text1.Text & "'" & Text2.Text & "'" & Text3.Text & "'" & Text4.Text & "'" & Text5.Text & "')"
cn.Close
Set cn=Nothing
Exit Sub
err:
MsgBox err.Description
End Sub
cn.Execute("insert into mathe values('" & Text1.Text & "','" & Text2.Text & "','" & Text3.Text & "','" & Text4.Text & "','" & Text5.Text & "')"
帮忙修正一下!