哦对不起
上面的错了(是用于sqlserver的)下面的是用于access的
Dim conn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Password= " & "" & ";User ID=Admin;Data Source=C:\Program Files\sdl\Setup1\db\帐目管理.mdb"
Dim myconnection As New OleDb.OleDbConnection(conn)
Dim mysqlcmd As New OleDb.OleDbCommand()