code:
Dim conycdata As ADODB.Connection
Dim rsdepeat As ADODB.Recordset
Dim rsteacher As ADODB.Recordset
Dim noddepeat As Node
Dim itmteacher As ListItem
Dim sqlteacher As StringPrivate Sub Form_Load()
sqlteacher = "select teacher.tea_name,depeat.dep_name from teacher,depeat where teacher.tea_dep=depeat.depeatid group by depeat.dep_name"
Set conycdata = New Connection
Set rsdepeat = New Recordset
Set rsteacher = New Recordset
conycdata.ConnectionString = "provider=Microsoft.Jet.OLEDB.3.51"
conycdata.Open App.Path & "\ycdata.mdb"
rsdepeat.Open "select * from depeat", conycdata
rsteacher.Open sqlteacher, conycdata
End Sub
Dim conycdata As ADODB.Connection
Dim rsdepeat As ADODB.Recordset
Dim rsteacher As ADODB.Recordset
Dim noddepeat As Node
Dim itmteacher As ListItem
Dim sqlteacher As StringPrivate Sub Form_Load()
sqlteacher = "select teacher.tea_name,depeat.dep_name from teacher,depeat where teacher.tea_dep=depeat.depeatid group by depeat.dep_name"
Set conycdata = New Connection
Set rsdepeat = New Recordset
Set rsteacher = New Recordset
conycdata.ConnectionString = "provider=Microsoft.Jet.OLEDB.3.51"
conycdata.Open App.Path & "\ycdata.mdb"
rsdepeat.Open "select * from depeat", conycdata
rsteacher.Open sqlteacher, conycdata
End Sub
sqlteacher = "select Sum(teacher.tea_name),depeat.dep_name from teacher,depeat where teacher.tea_dep=depeat.depeatid group by depeat.dep_name"
出现提示::
由于Microsoft jet数据引擎含有一个无效的数据类型字段,导致它不能执行SQL语句字段。。
如何解决?
如何解决?
把provider=Microsoft.Jet.OLEDB.3.51改成provider=Microsoft.Jet.OLEDB.4.0