Question

VB程序代码，找不到可安装的ISAM，对象refresh的方法IAdodc失败

哪位大侠帮我解决一下？
Adodc1.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0 ; DataSource=" & App.Path & "\student.mdb;Persist SecurityInfo = False"
Adodc1.RecordSource = "select * from student ": Adodc1.Refresh

总是显示Adodc1.Refresh的问题。

Adodc1.RecordSource = " select * from student order by 出生年月"

Adodc1.Refresh
这句话哪里有问题？

Adodc1.RecordSource = " select * from student where 姓名 = " '" & Text8.Text & "'"

Adodc1.Refresh
这句话哪里有问题？

都是显示说Adodc1.Refresh的错误.

万谢！！！

Answer 1

Adodc1.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0 ; DataSource=" & App.Path & "\student.mdb;Persist SecurityInfo = False"
DataSource变成Data Source
SecurityInfo 变成 Security Info
Adodc1.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source=" & App.Path & "\student.mdb;Persist Security Info = False"
估计是copy的，下次用Adodc自己生成好了再改吧