Access のmdb にアクセス
vbscript からAccess のmdb にアクセスする方法
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- -
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Set conn = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")
conn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=c:\mdb\passwd.mdb"
rs.Open "select * from password", conn ,3,3
rs.MoveFirst
' MsgBox "--" & rs.Fields("氏名")
MsgBox "--" & rs.Fields(2)
MsgBox "--" & rs.Fields(3)
rs.MoveNext
rs.Close
conn.Close
msgbox "end"