VB求助 有加分 高手快来 急急急!

来源:百度知道 编辑:UC知道 时间:2024/05/22 02:19:22
本人写了段程序如下,实现的是根据输入关键字查询分数,
运行时却出现了错误,不知该怎么调试,请高手帮忙
错误提示是:Unrecognized database format'c:\Documents and Settings\gg\桌面\xx\student.mdb
请高手帮忙,有加分
Private Sub Command1_Click()
On Error Resume Next
Dim s() As String, i As Integer, sql, milnk, mpath As String
mpath = App.Path
If Right(mpath, 1) <> "\" Then mpath = mpath + "\"
sql = "Select * From 学生表 Where"
If Text1.Text = "" Then
rsponse = MsgBox("请输入关键字", vbOKOnly, "提示")
If reponse = 1 Then Text1.SetFocus
Else
If Text1.Text > "" Then
s = Split(Text1.Text, " ")
End If
For i = 0 To UBound(s) - 1
If IsNumeric(s(i)) Then
k = Len(s(i))
Select Case k
Case 1
sql = sql + "学号=00'" & s(i) & "'"
Case 2
sql = sql + "学号=0'" & s(i) & "'&qu

不可识别的数据库格式

SQL语句里有错误
sql = sql + "学号=0'" & s(i) & "'"
学号=0'****'

但问题应该不是出在这里,ACCESS的驱动太老了,用4.0看看
可能3.51不支持access2000版本

还有:

mlink = mlink + "Data Source = " + mpath + "\student.mdb"

错在这:注意单引号。
sql = sql + "学号=00'" & s(i) & "'"
sql = sql + "学号=0'" & s(i) & "'"
sql = sql + "学号='" & s(i) & "'"
如果学号字段是字符型的。应该是:
sql = sql + "学号='00" & s(i) & "'"

这种对比法也错:
ElseIf s(i) = "计算机" Or "英语" Or "日语" Or "法律" Then

应该用elseIf s(i) = "计算机" Or s(i) = "英语"......