我用adodc控件 在connectionstring 里填上Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\Documents and Settings\Bstar\My Documents\course.mdb再在record source里填写查询语句 工作正常刚看了一本书
说是可以这样设置
Private Sub Form_Load()
with
Adodc1.ConnectionString = "Driver={Microsoft Access Driver(*.mdb)};Dbq=C:\Documents and Settings\Bstar\My Documents\course.mdb"
recordsource="...."
end with
我用这段语句可是不行 请问这有什么问题?该怎么写?
说是可以这样设置
Private Sub Form_Load()
with
Adodc1.ConnectionString = "Driver={Microsoft Access Driver(*.mdb)};Dbq=C:\Documents and Settings\Bstar\My Documents\course.mdb"
recordsource="...."
end with
我用这段语句可是不行 请问这有什么问题?该怎么写?
这样写试一下
Adodc1.RecordSource = ""
Adodc1.ConnectionString = "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\Documents and Settings\Bstar\My Documents\course.mdb"
Adodc1.RecordSource = "select * from ......."
Adodc1.Refresh
.ConnectionString = "Driver={Microsoft Access Driver(*.mdb)};Dbq=C:\Documents and Settings\Bstar\My Documents\course.mdb"
.recordsource="SQL"
end with
.ConnectionString = "Driver={Microsoft Access Driver(*.mdb)};Dbq=C:\Documents and Settings\Bstar\My Documents\course.mdb"
.RecordSource="...."
End WithEnd Sub
http://blog.csdn.net/qvbhdnvto/archive/2006/09/18/1233875.aspx