利用下面的程式碼打算利用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
請先 登入 以發表留言。