試驗一下ON-FLY 的連接

來源: 真源湛寂 於 2006-10-16 06:23:56 [] [博客] [舊帖] [給我悄悄話] 閱讀數 : (413 bytes)


Set MyConn = Server.CreateObject("ADODB.Connection")
MdbFilePath = Server.MapPath("sample.mdb")
MyConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath & ";"
SQL_query = "SELECT * FROM 您的表"
Set RS = MyConn.Execute(SQL_query)
WHILE NOT RS.EOF
%>


RS.MoveNext
WEND
%>

請您先登陸，再發跟帖！