利用下面的程式碼打算利用ADO來執行一SQL的查詢...卻出現了"找不到可安裝的ISAM"的錯誤...ActiveX Data Objects從2.0, 2.1, 2.5, 2.6, 2.7都試過了,還是會出現一樣的問題...麻煩各位先進幫幫小弟...
ps.我的Access是Offiece XP的版本...Visual Basic有安裝過VB SP5...
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim connstr As String
Dim SQL As String
connstr =
"Provider=Microsoft.Jet.OLEDB.4.0;DataSource=C:\Documents and Settings\陳信良\My Documents\Reaction Database.mdb"
conn.Open connstr
SQL = "Select * From SF6 Where Reactant1 = 'e'"
rs.CursorLocation = adUseClient
rs.Open SQL, conn, adOpenStatic, adLockBatchOptimistic
ps.我的Access是Offiece XP的版本...Visual Basic有安裝過VB SP5...
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim connstr As String
Dim SQL As String
connstr =
"Provider=Microsoft.Jet.OLEDB.4.0;DataSource=C:\Documents and Settings\陳信良\My Documents\Reaction Database.mdb"
conn.Open connstr
SQL = "Select * From SF6 Where Reactant1 = 'e'"
rs.CursorLocation = adUseClient
rs.Open SQL, conn, adOpenStatic, adLockBatchOptimistic
文章標籤
全站熱搜
vbcity的leader幫我找到原因了... 兇手是connstr...必須寫成 "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\My Documents\Reaction Database.mdb"... 乍看之下好像一模一樣...仔細一看...Data跟Source之間多了一個空格... 就是這個空格浪費了我兩小時的時間...提供給大家參考...^^!!!